No, no... in pgsql 7.3 you can do "insert into test (columnName)
values (DEFAULT)" and it works! It just doesn't work for prepared
statements. Maybe I should join the pgsql-developers list?
On Fri, 2002-11-22 at 14:45, Neil Conway wrote:
> Felipe Schnack <felipes@ritterdosreis.br> writes:
> > Yes, I did... sorry, the error message was "parser: parse error at
> > or near "default" at character 26". Seems to me that execute doesn't
> > "know" DEFAULT keyrword?
>
> Yeah, the handling of the DEFAULT keyword is currently done within the
> parsing of the INSERT statement itself. Not sure if that should be
> changed...
>
> You can insert the default value into a column by excluding it from
> the column list in the INSERT statement -- that should work for you
> here...
>
> Cheers,
>
> Neil
>
> --
> Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC
>
--
Felipe Schnack
Analista de Sistemas
felipes@ritterdosreis.br
Cel.: (51)91287530
Linux Counter #281893
Faculdade Ritter dos Reis
www.ritterdosreis.br
felipes@ritterdosreis.br
Fone/Fax.: (51)32303328