Re: Representing a SRF return column in catalogs

Поиск
Список
Период
Сортировка
От Atri Sharma
Тема Re: Representing a SRF return column in catalogs
Дата
Msg-id CAOeZVictOjuvm4+x6takef5bbuGFZUWX_Kdo5HV1AWVSiT540Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Representing a SRF return column in catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers


On Saturday, November 8, 2014, Tom Lane <tgl@sss.pgh.pa.us> wrote:

I'm confused too.  The original example seemed to imagine that details
of a query (not the function, but the calling query) would be stored in
the catalogs, which is completely nuts.

pg_proc already has provisions to remember the names of output parameters
of a function, but it seems like you want something else than that, only
it's not very clear what.  Are you trying to say that you'd like to
represent the sort order of the output of a function?  If so, you'd have
to add new columns to pg_proc for that, but I can't see why we'd represent
that information in terms of column names.  A column number and a sort
operator would make more sense.


Exactly. I would like to represent the sort order of the output.

Thanks for catching it, I really need to stop writing emails without drinking coffee... 


--
Regards,
 
Atri
l'apprenant

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: recovery_target_time and standby_mode
Следующее
От: Robert Haas
Дата:
Сообщение: Re: [v9.5] Custom Plan API