Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
get id of insert in plpgsql function
- From: "A B" <gentosaker(at)gmail(dot)com>
- To: pgsql-novice(at)postgresql(dot)org
- Subject: get id of insert in plpgsql function
- Date: Thu, 22 May 2008 09:56:49 +0200
- Message-id: <dbbf25900805220056n7826a97ek576095a3e9372b99(at)mail(dot)gmail(dot)com>
If I have a table mytable (id serial, y integer) and wish to insert a row into the table in a plpgsql function, how can I catch the id (serial number) of the last inserted row?
- Follow-Ups:
- Re: get id of insert in plpgsql function
- From: A. Kretschmer
- Re: get id of insert in plpgsql function
- Prev by Date: recreating tables from global files
- Next by Date: Re: get id of insert in plpgsql function
- Previous by thread: recreating tables from global files
- Next by thread: Re: get id of insert in plpgsql function
- Indexes: