Chuck McDevitt <[EMAIL PROTECTED]> writes: > Doesn't ANSI standard interval syntax have the minus sign before the quotes? > Select interval -'2008-10';
They allow it either there or inside the quotes. We can't support outside-the-quotes unless we make INTERVAL a fully reserved word (and even then there are syntactic problems :-(). Putting the minus sign before INTERVAL works fine btw ... regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers