[Top][All Lists]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

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

From: Karsten Hilbert
Subject: [Gnumed-devel] doing VALID UNTIL programmatically in SQL ?
Date: Wed, 11 Jun 2003 14:59:53 +0200
User-agent: Mutt/

Hi all,

in a psql script for GnuMed ( I am using a
snippet like the following for setting up predefined test

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
GPG key ID E4071346 @
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

reply via email to

[Prev in Thread] Current Thread [Next in Thread]