Re: getting back autonumber just inserted

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: PFC <lists(at)boutiquenumerique(dot)com>
Cc: Michael Fuhr <mike(at)fuhr(dot)org>, lmeadors(at)apache(dot)org, pgsql-sql(at)postgresql(dot)org
Subject: Re: getting back autonumber just inserted
Date: 2005-07-08 13:27:46
Message-ID: 20050708132746.GA18363@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Jul 08, 2005 at 05:03:37 +0200,
PFC <lists(at)boutiquenumerique(dot)com> wrote:
>
> It's the first time I see a MySQLism in postgres !

This has meaning in more ways than one.

> However I like it, cos it might subvert some MySQL users, and
> provide easy answers to The Weekly Question on the mailing list (ie where
> is AUTO_INCREMENT) ?

More likely people will shoot themselves in the foot with this feature and come
to the mailing list with questions that take even more time to figure out
than telling them how to use currval(pg_get_serial_sequence().

IMO it is a bad idea to include this feature and that no sane developer will
make use of it in applications.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message PFC 2005-07-08 13:49:20 Re: two sums in one query
Previous Message Michael Fuhr 2005-07-08 12:32:30 Re: getting back autonumber ... Another MsSQL Comparation Question