On 04/06/2011 12:28 PM, John R Pierce wrote:
On 04/06/11 9:10 AM, Steve Crawford wrote:
select ii_purchased + your_interval_field * '1 year'::date as date
from inventory_item;
that SHOULD be written as...
select ii_purchased + your_interval_field * interval '1 year' as date
from inventory_item;
Correct. I meant ...::interval... but hadn't had my first coffee. :)
Cheers,
Steve
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
