Re: FW: statement failure

both dev and prod are 8.2.15
Version string PostgreSQL 8.2.15 (Greenplum Database 4.2.2.4 build 1) on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 4.4.2 compiled on Oct 3 2012 20:28:56

can you tell me what change in 8.3 maybe Greenplum incorporated some of the changes in their build.

Thanks

From: Merlin Moncure [mailto:mmoncure(at)gmail(dot)com]
Sent: Wednesday, March 06, 2013 9:47 AM
To: Little, Douglas
Cc: PostgreSQL General (pgsql-general(at)postgresql(dot)org)
Subject: Re: [GENERAL] FW: statement failure

On Wed, Mar 6, 2013 at 9:38 AM, Little, Douglas <DOUGLAS(dot)LITTLE(at)orbitz(dot)com<mailto:DOUGLAS(dot)LITTLE(at)orbitz(dot)com>> wrote:
Hi,

I have a dev and prod Greenplum system (4.2.2.4) that is based on PG 8.2.15
I have a function that's been working fine on dev, but when implemented in prod had a syntax error.
I was easily able to fix by casting, but I can't see why the message didn't show up on our dev machine.

can you double check pg version on both dev and prod. My guess is that prod is 8.3+ -- casting rules were tightened with 8.3.

merlin