Re: truncated string problem

Alvaro Herrera <[email protected]> Tue, 29 Jul 2003 16:51:50 -0400

Newsgroups	gmane.comp.db.postgresql.general,gmane.comp.python.db.pypgsql.user
Message-ID	<[email protected]>

On Wed, Jul 30, 2003 at 08:38:47AM +1200, Rob Brown-Bayliss wrote:

> 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");

Huh... don't use double quotes in literal values, just single quotes:

 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');

-- 
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El miedo atento y previsor es la madre de la seguridad" (E. Burke)

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html