[Top][All Lists]

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

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

From: Jimmie H. Apsey
Subject: [Gnumed-devel] Re: [GENERAL] doing VALID UNTIL programmatically in SQL ?
Date: Wed, 11 Jun 2003 09:41:08 -0400
User-agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.0.1) Gecko/20021105

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 ( 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

reply via email to

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