Emanuel Araújo wrote: > The field where the problem occurs is of type float or double, when extracting data from firebird, it > creates the tables materialized as type text. There is problem with null values or zero bytes. There > are three records with value "1.5" and are those records that generates the error. >> What I would do is check how the data look in Perl. >> Build a simple Perl script that selects the problem data and display them byte for byte. >> >> That should help understand the problem. > I will try Another possibility is to use the 8.4 installation where things work and display the actual content with something like: SELECT encode(col, 'escape') FROM tab WHERE ... That should show any zero bytes. Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
