Re: truncated string problem - Mailing list pgsql-general

From Eric Clark
Subject Re: truncated string problem
Date
Msg-id 1059511597.10852.4.camel@eric
Whole thread Raw
In response to truncated string problem  (Rob Brown-Bayliss <rob@zoism.org>)
List pgsql-general
On Tue, 2003-07-29 at 13:38, Rob Brown-Bayliss wrote:
>
> Hi, Running the following SQL via pypgsql:
>
> INSERT INTO "songs" ("p_key", "title", "artist", "date", "album",
> "tracknumber", "time", "file") VALUES
> ("ea0e89f596619af1837f424c0767ffd9", "Sugar Mountain", "Neil Young",
> "1979", "Live Rust", "1", "302.226666667",
> "/oggs/Neil_Young-Sugar_Mountain.ogg");

Double quotes are reserved for identifier's like table and column
names.  You should use single quotes's for your values.  phpPgAdmin is
probably rewriting your statement.

Eric


pgsql-general by date:

Previous
From: Rob Brown-Bayliss
Date:
Subject: truncated string problem
Next
From: Freddy Menjívar M.
Date:
Subject: Re: Does the block of code in a stored procedure execute as a transaction?