Re: Stored Functions

* Yolanda Phillips (yphillips@xxxxxxxxxxxxxxxxxxx) wrote:
> I'm wanting to do an insert, then if it was successfull the function should
> return the id. This id is using a sequence.nextval(). How do I return the
> new id?

After the insert statement, run a new statement:
SELECT curval('sequencename')

This statement will return the id.


Hope this helps,
Anders

--
Anders Hermansen
YoYo Mobile as

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html