Re: Re: Outstanding patches

Jan Wieck <janwieck@yahoo.com>

From: Jan Wieck <JanWieck@Yahoo.com>
To: Ian Lance Taylor <ian@airs.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Bruce Momjian <pgman@candle.pha.pa.us>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2001-05-15T15:41:51Z
Lists: pgsql-hackers
Ian Lance Taylor wrote:
>
> Oracle PL/SQL supports this, and PL/SQL code that I've seen uses it
> extensively.  PL/pgSQL supports %TYPE in all places a type may be
> used, except parameter and return types.

    It's  not  PL/pgSQL's  fault  here.  The  pg_proc entries are
    created by the CREATE FUNCTION utility  command  that's  used
    for  all languages.  So what we're talking about affects SQL,
    C, PL/Tcl, PL/Perl, PL/Python and whatnot too. PL/pgSQL might
    live  with that very well, because it has some automatic type
    conversion (using the actual values typoutput and the  needed
    types  typinput functions) to convert values on the fly.  But
    a C function receiving a different type all of a sudden is  a
    good candidate to coredump the backend.


Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #



_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com