Re: [HACKERS] PL/PGSQL and drop/create table

2005-09-07 Thread Michael Fuhr
On Wed, Sep 07, 2005 at 03:51:05PM +0400, Teodor Sigaev wrote: > ERROR: relation with OID 16628 does not exist > CONTEXT: SQL statement "SELECT count(*) from foo where bar = $1 " http://www.postgresql.org/docs/faqs.FAQ.html#4.19 -- Michael Fuhr ---(end of broadcast)-

[HACKERS] PL/PGSQL and drop/create table

2005-09-07 Thread Teodor Sigaev
# create table foo ( bar int ); CREATE TABLE # create or replace function func (int) returns int as $$ DECLARE IID alias for $1; CNT int; BEGIN select into CNT count(*) from foo where bar = IID; RETURN CNT; END; $$ language plpgsql; CREATE FUNCTION # sele