Re: truncated string problem

From: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
To: Rob Brown-Bayliss <rob(at)zoism(dot)org>
Cc: PostgreSQL General List <pgsql-general(at)postgresql(dot)org>, Pypgsql List <pypgsql-users(at)lists(dot)sourceforge(dot)net>
Subject: Re: truncated string problem
Date: 2003-07-29 20:51:50
Message-ID: 20030729205150.GG6320@dcc.uchile.cl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2003-07-29 21:42:37 Re: how to get postgresql page size?
Previous Message Freddy Menjívar M. 2003-07-29 20:47:37 Re: Does the block of code in a stored procedure execute as a transaction?