Postgres Pro
Downloads
Home   >   mailing lists

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

From karinos57
Subject Re: using Replace funcion in postgresql
Date
Msg-id 1379380822565-5771171.post@n5.nabble.com
Whole thread Raw
In response to Re: using Replace funcion in postgresql  (John R Pierce <pierce@hogranch.com>)
Responses Re: using Replace funcion in postgresql  (Adrian Klaver <adrian.klaver@gmail.com>)
List pgsql-general
Tree view 
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



--
View this message in context:
http://postgresql.1045698.n5.nabble.com/using-Replace-funcion-in-postgresql-tp5771164p5771171.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Bret Stern
Date:
Subject: Re: Using ODBC and VBA to pull data from a large object
Next
From: karinos57
Date:
Subject: remove everything before the period