Re: [GENERAL] FW: statement failure

2013-03-07 Thread Magnus Hagander
On Thu, Mar 7, 2013 at 5:33 PM, Little, Douglas wrote: > both dev and prod are 8.2.15 > > Version stringPostgreSQL 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 i

Re: [GENERAL] FW: statement failure

2013-03-07 Thread Little, Douglas
build. Thanks From: Merlin Moncure [mailto:mmonc...@gmail.com] Sent: Wednesday, March 06, 2013 9:47 AM To: Little, Douglas Cc: PostgreSQL General (pgsql-general@postgresql.org) Subject: Re: [GENERAL] FW: statement failure On Wed, Mar 6, 2013 at 9:38 AM, Little, Douglas mailto:douglas.lit

Re: [GENERAL] FW: statement failure

2013-03-06 Thread Merlin Moncure
On Wed, Mar 6, 2013 at 9:38 AM, Little, Douglas 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 f

[GENERAL] FW: statement failure

2013-03-06 Thread Little, Douglas
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. I've review