Re: doing VALID UNTIL programmatically in SQL ?

I think it has to be done like this: "now() + '@ 6 month' as
six_months_from_now;" which yields

six_months_from_now
------------------------
2003-12-11 09:38:24-05
(1 row)

Jim Apsey
--------------------------------------------------------------------------------------
Karsten Hilbert wrote:

>Hi all,
>
>in a psql script for GnuMed (www.gnumed.org) I am using a
>snippet like the following for setting up predefined test
>accounts:
>
>CREATE USER "test-doc"
> WITH PASSWORD 'test-doc'
> IN GROUP "gm-doctors", "gm-public"
> VALID UNTIL '2003-09-30'
>;
>
>I would like to constrain their validity to, say, six months. I
>have tried but not found a way to tell the VALID UNTIL clause
>something like
>
> now() + '6 months'::interval
>
>Anyone have a suggestion (short of calculating in the client at
>runtime and substituting) on how to do this in plain SQL ?
>
>Thanks a lot,
>
>Karsten Hilbert, MD
>GnuMed i18n coordinator
>
>