From: | "Hiroshi Inoue" <Inoue(at)tpf(dot)co(dot)jp> |
---|---|
To: | "Jan Wieck" <jwieck(at)debis(dot)com>, "Bruce Momjian" <maillist(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | <pgsql-hackers(at)postgreSQL(dot)org> |
Subject: | RE: [HACKERS] Projecting attributes of function return values |
Date: | 1998-12-14 23:48:58 |
Message-ID: | 000b01be27bc$513f7240$2801007e@cadzone.tpf.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> -----Original Message-----
> From: Jan Wieck [mailto:jwieck(at)debis(dot)com]
> Sent: Monday, December 14, 1998 6:38 PM
> To: Bruce Momjian
> Cc: Inoue(at)tpf(dot)co(dot)jp; pgsql-hackers(at)postgreSQL(dot)org
> Subject: Re: [HACKERS] Projecting attributes of function return values
>
>
> >
> > I have applied this to the CURRENT tree, so the fix will appear in 6.5.
> > I have not applied it to the RELEASE tree, so it will not be in 6.4.1.
> > Not sure there is going to be enough testing for that.
> >
> > Thanks for the patch.
> >
> > >
> > > Hi all
> > >
> > > I have a simple patch about the treatment of functions.
> > > But it may be self-satisfied.
> > > Please check my patch at the end of this posting.
> > >
> > > Case 1. executor evaluates functions twice
> > >
> > > create table a (elem int4);
> > > create function ax2(int4) returns a as
> > > 'select $1*2;' language 'sql';
>
> It addresses a problem I've mentioned some time ago.
> Functions returning sets or complex types have targetlists,
> but these aren't handled correctly in the executor.
>
It includes the fact that func_tlist of Func node is not used to project
attributes of function return values except when functions are written
in 'sql' language ?
and
the fact that PL/pgSQL functions return different type(HeapTuple)
from 'sql' functions which return the pointer to TupleTableSlot node ?
My samples are all written in 'sql' language.
Seems the cases I mentioned are simple bugs.
Thanks.
Hiroshi Inoue
Inoue(at)tpf(dot)co(dot)jp
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas G. Lockhart | 1998-12-15 01:01:01 | Re: [HACKERS] JOIN syntax. Examples? |
Previous Message | Jackson, DeJuan | 1998-12-14 21:48:25 | RE: [HACKERS] JOIN syntax. Examples? |