From: | Joe Conway <mail(at)joeconway(dot)com> |
---|---|
To: | Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> |
Cc: | pgsql-hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Proposal: anonymous composite types for Table Functions |
Date: | 2002-07-25 07:00:48 |
Message-ID: | 3D3FA220.7000707@joeconway.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-patches |
Christopher Kings-Lynne wrote:
> Why is there the requirement to declare the type at SELECT time at all? Why
> not just take what you get when you run the function?
The column names and types are determined in the parser, and used in the
planner, optimizer, and executor. I'm not sure how the backend could
plan a join or a where criteria otherwise.
Remember that the function has to look just like a table or a subselect
(i.e a RangeVar). With a table, the column names and types are
predefined. With a subselect, parsing it yields the same information.
With a table function, we need some way of providing it -- i.e. either
with a predefined type, or now with a definition right in the FROM clause.
Joe
From | Date | Subject | |
---|---|---|---|
Next Message | Zeugswetter Andreas SB SD | 2002-07-25 07:02:30 | Re: Proposal: anonymous composite types for Table Functions (aka SRFs) |
Previous Message | Tatsuo Ishii | 2002-07-25 03:29:08 | Re: RESET SESSION AUTHORIZATION |
From | Date | Subject | |
---|---|---|---|
Next Message | Christopher Kings-Lynne | 2002-07-25 07:16:14 | Re: Proposal: anonymous composite types for Table Functions (aka SRFs) |
Previous Message | Neil Conway | 2002-07-25 03:40:43 | regression test fix |