Re: truncated string problem

Eric Clark <[email protected]> 29 Jul 2003 13:46:36 -0700

Newsgroups	gmane.comp.db.postgresql.general,gmane.comp.python.db.pypgsql.user
Message-ID	<1059511597.10852.4.camel@eric>

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


---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org