Subject: Re: Sequences
From: Markus Bertheau <twanger@bluetwanger.de>
To: "Hunter, Ray" <rhunter@enterasys.com>
Cc: postgres sql list <pgsql-sql@postgresql.org>
In-Reply-To: <59358A738F45D51186A30008C74CE250E81373@slc-exc1.ctron.com>
References: <59358A738F45D51186A30008C74CE250E81373@slc-exc1.ctron.com>
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature";
	boundary="=-wpwqOzZr1xTX0bAALnhp"
Date: 11 Feb 2002 15:22:30 +0100
Message-Id: <1013437356.3653.28.camel@entwicklung01.cenes.de>
Mime-Version: 1.0

--=-wpwqOzZr1xTX0bAALnhp
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

On Mon, 2002-02-11 at 14:43, Hunter, Ray wrote:
> I have various sequences in my database set up for ids.  My question is:
> How can I get the current value of the sequence without creating a session
> and using the currval function?
>=20
> I would like to take the current value of the sequence and use it for a
> value in an insert statement.
>=20
>=20
> Example:
>=20
> 	insert into users ( "user_id", "user_fname", "user_lname",
> "user_email" )
> 	values ( 'current sequence', 'Ray', 'Hunter',
> 'rhunter@enterasys.com' );
>=20

You probably wouldn't want to use the current but the next value of the
sequence. Common solution is to set the default for the column user_id
to something like
nextval(users_user_id_seq"::text)
and omit user_id in the insert statement such that the default value is
taken.

Markus Bertheau

Cenes Data GmbH


--=-wpwqOzZr1xTX0bAALnhp
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQA8Z9OmKNEjAb345r4RApvEAKCA8RmvTXdJU+PiuZP+SMaC1xhxjgCdGGnW
Ng3J2NwGvT6rFO2wc8Wp0T0=
=E4zW
-----END PGP SIGNATURE-----

--=-wpwqOzZr1xTX0bAALnhp--