-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
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