Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: INSERT with RETURNING clause inside SQL function
- From: rintaant <antero(dot)rintamaki(at)netikka(dot)fi>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Re: INSERT with RETURNING clause inside SQL function
- Date: Wed, 30 Sep 2009 03:11:52 -0700 (PDT)
- Message-id: <25678362.post@talk.nabble.com> <text/plain>
you can try: CREATE OR REPLACE FUNCTION add_something(text, text) RETURNS integer AS $BODY$ DECLARE somevariable integer; BEGIN INSERT INTO sometable (id, foo, bar ) VALUES (DEFAULT, $1, $2 ) RETURNING id INTO somevariable; return somevariable; END;$BODY$ LANGUAGE 'plpgsql' VOLATILE; -- View this message in context: http://www.nabble.com/INSERT-with-RETURNING-clause-inside-SQL-function-tp20312197p25678362.html Sent from the PostgreSQL - general mailing list archive at Nabble.com.
- Prev by Date: Re: Collation in ORDER BY not lexicographical
- Next by Date: PostgreSQL Macro Query
- Previous by thread: Where can I get the number of plans that considered by Planner?
- Next by thread: PostgreSQL Macro Query
- Indexes: