Postgres Pro
Downloads
Home   >   mailing lists

Re: using Replace funcion in postgresql - Mailing list pgsql-general

From Adrian Klaver
Subject Re: using Replace funcion in postgresql
Date
Msg-id 52386B44.20902@gmail.com
Whole thread Raw
In response to Re: using Replace funcion in postgresql  (karinos57 <karinos57@hotmail.com>)
List pgsql-general
Tree view 
On 09/16/2013 06:20 PM, karinos57 wrote:
> just as FYI the database i am using is Netezza so my data type is CHARACTER
> VARYING(6).  The error i am getting is 'Buffer Overflow'.
>   So the funny thing is when i change this '' to this ' ' then the query runs
> but it is putting a blank space between the values like this 88 97
> but i get an error when i only make with out space like this ''.  thanks

Alright now I am confused. Your subject says using replace in Postgres,
yet now you say you are using Netezza, which is it?


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: tdev457
Date:
Subject: Number of WAL segment
Next
From: David Johnston
Date:
Subject: Re: best practice for || set of rows --> function --> set of rows