Re: calling functions in select - Mailing list pgsql-general

From Jakub Ouhrabka
Subject Re: calling functions in select
Date
Msg-id Pine.LNX.4.33.0204241111340.22603-100000@u-pl1.ms.mff.cuni.cz
Whole thread Raw
In response to calling functions in select  (Jakub Ouhrabka <jouh8664@ss1000.ms.mff.cuni.cz>)
Responses Re: calling functions in select  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> 1)
> FOR lr_rec IN SELECT func(table.x, ...) FROM table,... WHERE ... LOOP
> END LOOP;
>
> 2)
> FOR lr_rec IN SELECT * FROM table,... WHERE ... LOOP
>     li_x := func(lr_rec.x, ...);
> END LOOP;

i'll answer myself, it depends on whether func is iscachable or not,
right?

kuba


pgsql-general by date:

Previous
From: "ARP"
Date:
Subject: Bug or syntax error in my update query with a FROM statement ?
Next
From: Alejandro Fernandez
Date:
Subject: Re: Connections per second?