Postgres Pro
Downloads
Home   >   mailing lists

Re: Plpgsql function and variable substitute - Mailing list pgsql-general

From Alban Hertroys
Subject Re: Plpgsql function and variable substitute
Date
Msg-id 464B1B88.2000806@magproductions.nl
Whole thread Raw
In response to Plpgsql function and variable substitute  (Jiří Němec <konference@menea.cz>)
List pgsql-general
Tree view 
Jiří Němec wrote:
> SET expiretime = expiretime + interval 'lifetime days'
> SET expiretime = expiretime + interval || lifetime || 'days'

SET expiretime = expiretime + lifetime * interval '1 day'

--
Alban Hertroys
alban@magproductions.nl

magproductions b.v.

T: ++31(0)534346874
F: ++31(0)534346876
M:
I: www.magproductions.nl
A: Postbus 416
   7500 AK Enschede

// Integrate Your World //

pgsql-general by date:

Previous
From: Magnus Hagander
Date:
Subject: Re: dns less connection
Next
From: Andreas
Date:
Subject: Re: dns less connection