Re: Support for %TYPE in CREATE FUNCTION - Mailing list pgsql-hackers

From Ian Lance Taylor
Subject Re: Support for %TYPE in CREATE FUNCTION
Date
Msg-id siitiiy749.fsf@daffy.airs.com
Whole thread Raw
In response to Re: Support for %TYPE in CREATE FUNCTION  (Jan Wieck <JanWieck@Yahoo.com>)
Responses Re: Support for %TYPE in CREATE FUNCTION
List pgsql-hackers
Jan Wieck <JanWieck@Yahoo.com> writes:

>     What most of those if favor for doing it right now want is an
>     easy  Oracle->PostgreSQL  one-time  porting path. Reasonable,
>     but solveable with some external preprocessor/script too.

Can you explain how an external preprocessor/script addresses the
issue of %TYPE in a function definition?  Presumably the preprocessor
has to translate %TYPE into some definite type when it creates the
function.  But how can a preprocessor address the issue of what to do
when the table definition changes?  There still has to be an entry in
pg_proc for the procedure.  What happens to that entry when the table
changes?

You seem to be saying that %TYPE can be implemented via some other
mechanism.  That is fine with me, but how would that other mechanism
work?  Why it would not raise the exact same set of issues?

Ian


pgsql-hackers by date:

Previous
From: "D. Hageman"
Date:
Subject: Re: PL/pgSQL CURSOR support
Next
From: Jan Wieck
Date:
Subject: Re: Cache for query plans