Re: EXECUTE problems - Mailing list pgsql-general

From Neil Conway
Subject Re: EXECUTE problems
Date
Msg-id 87bs4h365a.fsf@mailbox.samurai.com
Whole thread Raw
In response to Re: EXECUTE problems  (Felipe Schnack <felipes@ritterdosreis.br>)
Responses Re: EXECUTE problems  (Felipe Schnack <felipes@ritterdosreis.br>)
List pgsql-general
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

pgsql-general by date:

Previous
From: Doug McNaught
Date:
Subject: Re: Lack of use of indexes
Next
From: Felipe Schnack
Date:
Subject: Re: EXECUTE problems