Re: zero-length string error ? - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: zero-length string error ?
Date
Msg-id 20030611121124.GC2547@wolff.to
Whole thread Raw
In response to Re: zero-length string error ?  (Aarni <aarni.ruuhimaki@kymi.com>)
Responses Re: zero-length string error ?  (Aarni <aarni.ruuhimaki@kymi.com>)
List pgsql-novice
On Wed, Jun 11, 2003 at 12:54:32 +0300,
  Aarni <aarni.ruuhimaki@kymi.com> wrote:
> Solved with a little help of my friends.
>
> Not related to power failure or redo, but no more single or double quoted
> comparisons with int-types in your sql-statement after 7.3.x ?

Double quotes are used for quoting identifiers not data.

The error message you got is one that you get when you use an empty
string as the value for a number. Older (7.2.x I think) versions
of Postgres used to treat these as a representation for 0. Now you
get an error.

pgsql-novice by date:

Previous
From: "Duncan Adams (DNS)"
Date:
Subject: Strange error in 7.3.1
Next
From: Aarni
Date:
Subject: Re: zero-length string error ?