Re: OID's

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Leen Besselink <leen(at)wirehub(dot)nl>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: OID's
Date: 2004-10-23 16:09:23
Message-ID: 20041023160923.GB18478@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, Oct 23, 2004 at 14:52:31 +0200,
Leen Besselink <leen(at)wirehub(dot)nl> wrote:
>
> id = nextval ("whatever_id_seq");
> insert into whatever (id, text) values (id, 'something');
>
> Something that works always... better, but you need to know the name of
> the sequence, bummer.

In 8.0 (currently in beta) there is a supplied function to return this
string reliably.

In response to

  • OID's at 2004-10-23 12:52:31 from Leen Besselink

Browse pgsql-general by date

  From Date Subject
Next Message Stephan Szabo 2004-10-23 16:18:40 Re: OID's
Previous Message Bruno Wolff III 2004-10-23 16:05:36 Re: returning inserted rows, derived tables design