Re: row_to_json bug with index only scans: empty keys!

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: row_to_json bug with index only scans: empty keys!
Дата
Msg-id 23873.1415470163@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: row_to_json bug with index only scans: empty keys!  (Andrew Dunstan <andrew@dunslane.net>)
Ответы Re: row_to_json bug with index only scans: empty keys!  (Ross Reedstrom <reedstrm@rice.edu>)
Список pgsql-hackers
Oh, some more fun: a RowExpr that's labeled with a named composite type
(rather than RECORD) has the same issue of not respecting aliases.
Continuing previous example with table "foo":

regression=# create view vv as select * from foo;
CREATE VIEW
regression=# select row_to_json(q) from vv q;  row_to_json   
-----------------{"f1":1,"f2":2}
(1 row)

regression=# select row_to_json(q) from vv q(a,b);  row_to_json   
-----------------{"f1":1,"f2":2}
(1 row)

So that's another case we probably want to change in HEAD but not the back
branches.
        regards, tom lane



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

Предыдущее
От: Andres Freund
Дата:
Сообщение: Re: Add CREATE support to event triggers
Следующее
От: Sehrope Sarkuni
Дата:
Сообщение: Re: Fw: [GENERAL] PLV8 and JS exports / referencing