Postgres Pro
Downloads
Home   >   mailing lists

Re: writing a function to mimic mysql last_insert_id - Mailing list pgsql-sql

From Josh Berkus
Subject Re: writing a function to mimic mysql last_insert_id
Date
Msg-id 200209111030.46289.josh@agliodbs.com
Whole thread Raw
In response to writing a function to mimic mysql last_insert_id  ("Beth Gatewood" <beth@vizxlabs.com>)
Responses Re: writing a function to mimic mysql last_insert_id  ("Beth Gatewood" <beth@vizxlabs.com>)
List pgsql-sql
Tree view 
Beth,

> I am wondering if I can get some input on the logic that I would need to
> code a function that would mimic mysql's last_insert_id()..

Um, what about CURRVAL('sequence-name')?

--
-Josh BerkusAglio Database SolutionsSan Francisco

pgsql-sql by date:

Previous
From: "Beth Gatewood"
Date:
Subject: writing a function to mimic mysql last_insert_id
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: writing a function to mimic mysql last_insert_id