Re: [GENERAL] EXECUTE and FOUND

2010/5/25 Bogdan Gusiev : > I am not sure if EXECUTE 'SELECT * FROM table" correctly sets FOUND > variable. > no - it doesn't it > EXECUTE 'SELECT * FROM ' || quote_ident(stmt.tablename) || ' limit 1'; > if found then >   > end if; > > Is there other way to check if EXECUTE 'SELECT ...' found

[GENERAL] EXECUTE and FOUND

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? -- Sent via pgsql-general mailing list (p