Re: Help with seq numbers...

On Mon, 14 Feb 2005 15:47:06 -0600, Cristian Prieto
<cristian@clickdiario.com> wrote:
> > why don't you use a serial? that way you don't have to insert it? i
> > usually let postgresql take care of it, and you can use currval to
> > return a value.
>
> That's the trouble, I need a sp that returns the user id of the last
> inserted user, and 0 if the username or email (another unique index) is
> already in the database...

what about using a serial for userid, but checking first is the meail
or username
already exists?

so, in your sp, do a: select count(*) from users where email=$1 or username=$2
and then avoid the insert and just return 0?

or that would be to much load?

javier