How to rename each field in ROW expression?

Поиск
Список
Период
Сортировка
От Itagaki Takahiro
Тема How to rename each field in ROW expression?
Дата
Msg-id AANLkTikYqoC1VzjmdSM4hvnHoXDRexG7ZOajp6=P6f9G@mail.gmail.com
обсуждение исходный текст
Ответы Re: How to rename each field in ROW expression?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
We can rename each field in VALUES clause:

=# SELECT * FROM (VALUES(123, 'ABC', NULL)) AS t(a,b,c); a  |  b  | c
-----+-----+---123 | ABC |
(1 row)

But I cannot find ways for ROW expression to do the same thing:

=# SELECT ROW(123, 'ABC', NULL) AS (a,b,c);
ERROR:  syntax error at or near "("
LINE 1: SELECT ROW(123, 'ABC', NULL) AS (a,b,c);                                       ^
=# SELECT (ROW(123, 'ABC', NULL)).*;
ERROR:  record type has not been registered

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.

-- 
Itagaki Takahiro


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bernd Helmle
Дата:
Сообщение: Re: [COMMITTERS] pgsql: Improved parallel make support
Следующее
От: Pavel Stehule
Дата:
Сообщение: Re: Per-column collation