EXECUTE and FOUND

From: Bogdan Gusiev <agresso(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: EXECUTE and FOUND
Date: 2010-05-25 10:20:31
Message-ID: 06fdab33-47a9-4af7-ad08-ac881d51054b@q8g2000vbm.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am not sure if EXECUTE 'SELECT * FROM table" correctly sets FOUND
variable.

EXECUTE 'SELECT * FROM ' || quote_ident(stmt.tablename) || ' limit 1';
if found then
....
end if;

Is there other way to check if EXECUTE 'SELECT ...' found something or
not?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2010-05-25 10:43:00 pg_dump cannot connect when executing by a script
Previous Message Grzegorz Jaśkiewicz 2010-05-25 10:18:28 Re: uppdate from postgersql 8.3.7 to 8.4.4