Re: [SQL] How does the planner treat a table function.

2005-03-16 Thread KÖPFERL Robert
d. This may mean that (as you asked) a select over a table function produces a temprary table and thus costs much ressources if the table is big. |-Original Message- |From: KÖPFERL Robert |Sent: Montag, 14. März 2005 12:26 |To: pgsql-sql@postgresql.org |Subject: [SQL] How does the planner t

[SQL] How does the planner treat a table function.

2005-03-14 Thread KÖPFERL Robert
Hi, we have got some tables (uw?) and functions. One function is defined like get_abc(): SELECT a,b,c from table_x; What happens if I query something like SELECT a,b from get_abc() where a=5; while table_x is rather big? Will PSQL at first query all records of table_x and then apply a where