Re: EXECUTE problems

From: Neil Conway <neilc(at)samurai(dot)com>
To: Felipe Schnack <felipes(at)ritterdosreis(dot)br>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: EXECUTE problems
Date: 2002-11-22 16:45:21
Message-ID: 87bs4h365a.fsf@mailbox.samurai.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Felipe Schnack <felipes(at)ritterdosreis(dot)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(at)samurai(dot)com> || PGP Key ID: DB3C29FC

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Felipe Schnack 2002-11-22 16:46:14 Re: EXECUTE problems
Previous Message Doug McNaught 2002-11-22 16:38:49 Re: Lack of use of indexes