Re: easy way to insert same value into 2 columns

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