Postgres Pro
Downloads
Home   >   mailing lists

Re: easy way to insert same value into 2 columns - Mailing list pgsql-general

From Sebastian Boeck
Subject Re: easy way to insert same value into 2 columns
Date
Msg-id 3F8E86B7.7090907@freenet.de
Whole thread Raw
In response to Re: easy way to insert same value into 2 columns  (Csaba Nagy <nagy@ecircle-ag.com>)
Responses Re: easy way to insert same value into 2 columns  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Jean-Michel POURE
Date:
Subject: Maping Oracle nvarchar2(lenght) to PostgreSQL varchar(lenght)
Next
From: Sebastian Boeck
Date:
Subject: Re: easy way to insert same value into 2 columns