From: | Martín Marqués <martin(at)bugs(dot)unl(dot)edu(dot)ar> |
---|---|
To: | "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com> |
Cc: | Lee Harr <missive(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: sequence in schema -- broken default |
Date: | 2004-01-23 20:37:44 |
Message-ID: | 1074890264.40118618ccbd6@bugs.unl.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Mensaje citado por "Joshua D. Drake" <jd(at)commandprompt(dot)com>:
> > # insert into x values();
> > ERROR: syntax error at or near ")" at character 22
> >
> Actually if you think about it, it makes sense. At least from the
> example you provide.
> insert into x values(5) is a integer insertion, and it just inserts into
> the first column but
> the second example insert into x values() specifies a blank value. A
> blank is a string
> (versus a NULL which is nothing) and the parser barfs on it with an
> integer. Although
> you will get a different error, insert into x values ('') will also fail.
I feel as if the error message is saying that there's an error near ")" because
there is a missing value (no value al all), not because he entered a string.
--
select 'mmarques' || '@' || 'unl.edu.ar' AS email;
-------------------------------------------------------
Martín Marqués | Programador, DBA
Centro de Telemática | Administrador
Universidad Nacional
del Litoral
-------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | vhikida | 2004-01-23 20:45:39 | Re: If table A value IS NULL then table B |
Previous Message | Martín Marqués | 2004-01-23 20:33:34 | Re: sequence in schema -- broken default |