John Udick <john.ud...@zionsbancorp.com> wrote: > We did notice that although now() failed, changing this to > 'now()'::date works (using single quotes around now()). That seem unrelated to the now() function. Casting a literal to a date/time/timestamp supports parsing out certain keywords, like 'now', 'today', 'yesterday', and 'tomorrow'. It's probably ignoring those parentheses. > Also, apparently we are not truly a Postgres database, but EMC's > Greenplum database. I will be working with our admins and EMC, > unless someone in Postgres can point out a specific version that > resolved this issue. > "PostgreSQL 8.2.15 (Greenplum Database 4.1.1.5 build 1) on > x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled > on Sep 20 2011 11:09:08" Yeah, I don't know how much the community lists can help with that implementation. It seems there is a bug in that version, but it might not be present in the community version. -Kevin
-- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
