Re: sequence in schema -- broken default

Mensaje citado por "Joshua D. Drake" <jd@commandprompt.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
-------------------------------------------------------