Re: easy way to insert same value into 2 columns

From: Sebastian Boeck <sebastianboeck(at)freenet(dot)de>
To: Csaba Nagy <nagy(at)ecircle-ag(dot)com>
Cc: Postgres general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: easy way to insert same value into 2 columns
Date: 2003-10-16 11:53:27
Message-ID: 3F8E86B7.7090907@freenet.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Csaba Nagy wrote:
> I can't 100% say it's safe to use, but no, other inserts will not
> influence the value, because currval will return the last sequence value
> used by the current session (i.e. the current connection). And of course
> you only have concurrent inserts using different connection, right ?
>
> HTH,
> Csaba.

Yes, that' right.

Thanks

Sebastian

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Sebastian Boeck 2003-10-16 11:58:21 Re: easy way to insert same value into 2 columns
Previous Message Jean-Michel POURE 2003-10-16 11:53:14 Maping Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght)