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