Re: anonymous composite types for Table Functions (aka

From: Joe Conway <mail(at)joeconway(dot)com>
To:
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-patches(at)postgresql(dot)org
Subject: Re: anonymous composite types for Table Functions (aka
Date: 2002-08-05 05:57:26
Message-ID: 3D4E13C6.6050700@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Joe Conway wrote:
> Tom Lane wrote:
>> Hm. I'd sort of expect the "z" to become both the table and column
>> alias in this case. What do you think?
>
> I guess that would make sense. I'll make a separate patch just for that
> change if that's OK.
>

Simple change -- patch attached.

test=# select * from myfoo1() as z;
z
----
1
2
3
(3 rows)

test=# select * from myfoo1();
myfoo1
--------
1
2
3
(3 rows)

test=# select * from myfoo1() as z(a);
a
----
1
2
3
(3 rows)

Joe

Attachment Content-Type Size
alias-fixup.2002.08.04.1.patch text/plain 912 bytes

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Joe Conway 2002-08-05 06:08:17 Re: FUNC_MAX_ARGS benchmarks
Previous Message Alvaro Herrera 2002-08-05 05:51:22 Re: Wacky OID idea

Browse pgsql-patches by date

  From Date Subject
Next Message Joe Conway 2002-08-05 06:19:37 Re: anonymous composite types for Table Functions (aka
Previous Message Joe Conway 2002-08-05 04:19:22 Re: anonymous composite types for Table Functions (aka