On 04/07/2010 08:34 PM, Tom Lane wrote:
Andy Colson<[email protected]> writes:I have this stored proc that works in pg 8.4. create or replace function roundts(ts timestamp) returns timestamp as $$ declare tmp integer; result timestamp; offset interval;OFFSET is a reserved word: http://developer.postgresql.org/pgdocs/postgres/sql-keywords-appendix.html Older versions of plpgsql didn't have quite the same rules about reserved words as the main SQL parser. In 9.0 the rules are much more nearly the same; in particular, unquoted use of reserved words won't work. regards, tom lane
Ah, thank you. Variable-name-changing-time again. -Andy -- Sent via pgsql-general mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
