Postgres Pro
Downloads
Home   >   mailing lists

Re: How to rename each field in ROW expression? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: How to rename each field in ROW expression?
Date
Msg-id 13938.1289834328@sss.pgh.pa.us
Whole thread Raw
In response to How to rename each field in ROW expression?  (Itagaki Takahiro <itagaki.takahiro@gmail.com>)
Responses Re: How to rename each field in ROW expression?
List pgsql-hackers
Tree view 
Itagaki Takahiro <itagaki.takahiro@gmail.com> writes:
> Is it possible to change names fields in ROW?
> We can use CREATE TYPE AS on ahead, but I'd like to
> change names of ROW expression in ad-hoc queries.

Why?  It's an anonymous type, you shouldn't care about names.
If you do, make a real named rowtype.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: MULTISET and additional functions for ARRAY
Next
From: Heikki Linnakangas
Date:
Subject: Re: Latches with weak memory ordering (Re: max_wal_senders must die)