On 03/14/2013 03:22 PM, Artur Zając wrote:
Why speed of executing (or planning) some very simple query from
string in pl/pgsql is dependent from whole query or why “FOR r IN
EXECUTE q” is significally slower from “FOR r IN query”?
The whole point of EXECUTE is that it's reparsed and plan
On Thu, Mar 14, 2013 at 2:22 PM, Artur Zając wrote:
> Hi,
>
>
>
> I have PostgreSQL 9.0.12 on Windows.
>
>
>
> I have some simple function:
>
>
>
> CREATE OR REPLACE FUNCTION sfunction() RETURNS BOOL AS
>
> $BODY$
>
> DECLARE
>
> q TEXT;
>
> r RECORD;
>
> BEGIN
>
> q='SELECT 1 from tb_klient LIM
Hi,
I have PostgreSQL 9.0.12 on Windows.
I have some simple function:
CREATE OR REPLACE FUNCTION sfunction() RETURNS BOOL AS
$BODY$
DECLARE
q TEXT;
r RECORD;
BEGIN
q='SELECT 1 from tb_klient LIMIT 0';
FOR r IN EXECUTE q
LOOP
END LOOP;
RETURN NULL;
RETURN NUL
