Re: zero-length string error ?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Aarni <aarni(dot)ruuhimaki(at)kymi(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: zero-length string error ?
Date: 2003-06-11 12:11:24
Message-ID: 20030611121124.GC2547@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wed, Jun 11, 2003 at 12:54:32 +0300,
Aarni <aarni(dot)ruuhimaki(at)kymi(dot)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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Aarni 2003-06-11 13:19:19 Re: zero-length string error ?
Previous Message Duncan Adams (DNS) 2003-06-11 10:54:56 Strange error in 7.3.1