Re: easy way to insert same value into 2 columns

Sebastian Böck <sebastianboeck@freenet.de>

From: Sebastian Boeck <sebastianboeck@freenet.de>
To: Csaba Nagy <nagy@ecircle-ag.com>
Cc: Postgres general mailing list <pgsql-general@postgresql.org>
Date: 2003-10-16T10:11:51Z
Lists: pgsql-general
Csaba Nagy wrote:
> For your specific question I don't know the answer.
> 
> For this particular case you could use:
> 
> create table your_table (
>   id integer default nextval ('public.zeit_id_seq'::text),
>   pos_id integer default currval ('public.zeit_id_seq'::text),
>   ...
> );
> 
> That would work fine as long as you use inserts which don't specify id
> if pos_id is not specified (otherwise the currval will throw you an
> error cause it cannot be called without nextval being called).
> 
> HTH,
> Csaba.

Thanks a lot, but is it save to use?

Do i always get the same value, even if an other insert is changing 
the sequence >public.zeit_id_seq< just at the same time?

Regards

Sebastian