Re: [PERFORM] Unfortunate expansion of composite types in union

2007-11-04 Thread Jens-Wolfhard Schicke
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Pavel Stehule wrote: > PostgreSQL doesn't support Common Table Expressions - you can write > SRF function: > > CREATE OR REPLACE FUNCTION c(integer) > RETURNS SETOF something AS $$ > DECLARE r RECORD; > o something; > BEGIN > FOR r IN SELECT * FROM

Re: [PERFORM] Unfortunate expansion of composite types in union

2007-11-02 Thread Pavel Stehule
Hello I am not sure, but this query will be evaluated efectivelly, because all necessary data will be in cache. PostgreSQL doesn't support Common Table Expressions - you can write SRF function: CREATE OR REPLACE FUNCTION c(integer) RETURNS SETOF something AS $$ DECLARE r RECORD; o something; B