[Gnumed-devel] Re: [GENERAL] doing VALID UNTIL programmatically in SQL ?

[Jimmie H. Apsey]

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
>