thank you very much for clarifying .....
On 15 December 2013 19:02, Andreas Brandl <m...@3.141592654.de> wrote: > John, > > ----- Ursprüngliche Mail ----- > > On 12/15/2013 4:17 PM, Andreas Brandl wrote: > > > select current_timestamp, current_timestamp + interval '2' day; > > > > that should be interval '2 day' (note the ' moved), and for a > > variable number passed as a parameter, try... > > # select current_timestamp + interval '2' day; > # select current_timestamp + interval '2' minute; > > all valid, but seems to only work in SQL (and not plpgsql) context. > > Regards, > Andreas > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
