On Thu, Jun 23, 2005 at 05:12:03PM -0700, David Bear wrote:
> I guess I'm too stupid to see the error, but I don't understand why
> the following fails.
> insert into person3 (asuid, fname, lname, addedby, addedon,
> slopbucket) values ("123455", "name", "name", "entered", "12/12/2004", NULL);
> ERROR: column "123455" does not exist
> is the double quote byting me?
String constants use single quotes (or dollar quotes as of 8.0);
double-quoted strings are interpreted as identifiers. See "Lexical
Structure" in the "SQL Syntax" chapter of the documentation:
If I'm not mistaken, this distinction is defined in the SQL standard.
In response to
pgsql-admin by date
|Next:||From: Bruno G. Albuquerque||Date: 2005-06-24 00:46:23|
|Subject: Re: stupid insert error|
|Previous:||From: David Bear||Date: 2005-06-24 00:12:03|
|Subject: stupid insert error|