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

Sebastian Boeck wrote:
> 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?

You can write a before insert trigger where you retrieve sequence value once and
set for two fields. That way it will ensure that both the fields would get same
value.

  HTH

  Shridhar