On 04/07/2010 08:34 PM, Tom Lane wrote:
Andy Colson<andy@xxxxxxxxxxxxxxx> 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 (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general