Re: Representing a SRF return column in catalogs - Mailing list pgsql-hackers

From Atri Sharma
Subject Re: Representing a SRF return column in catalogs
Date
Msg-id CAOeZVictOjuvm4+x6takef5bbuGFZUWX_Kdo5HV1AWVSiT540Q@mail.gmail.com
Whole thread Raw
In response to Re: Representing a SRF return column in catalogs  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Josh Berkus
Date:
Subject: Re: recovery_target_time and standby_mode
Next
From: Robert Haas
Date:
Subject: Re: [v9.5] Custom Plan API