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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
