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