Postgres Pro
Downloads
Home   >   mailing lists

Re: beginne' - inserting a record - Mailing list pgsql-general

From Raymond O'Donnell
Subject Re: beginne' - inserting a record
Date
Msg-id 43920721.18519.1CC02A2@localhost
Whole thread Raw
In response to beginne' - inserting a record  (Andrew Toth <tothaa@chello.hu>)
List pgsql-general
Tree view 
On 3 Dec 2005 at 21:48, Andrew Toth wrote:

> MediaBin=# insert into media values ("000", 120, "00001");
> ERROR:  column "000" does not exist

I think you should use single-quotes rather than doubles:

  insert into media values ('000', 120, '00001');

--Ray.

-------------------------------------------------------------
Raymond O'Donnell     http://www.galwaycathedral.org/recitals
rod@iol.ie                          Galway Cathedral Recitals
-------------------------------------------------------------

pgsql-general by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: Reduce NUMERIC size by 2 bytes, reduce max length to 508 digits
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: beginne' - inserting a record