Re: EXECUTE problems

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: EXECUTE problems
Дата
Msg-id 87bs4h365a.fsf@mailbox.samurai.com
обсуждение исходный текст
Ответ на Re: EXECUTE problems  (Felipe Schnack <felipes@ritterdosreis.br>)
Ответы Re: EXECUTE problems  (Felipe Schnack <felipes@ritterdosreis.br>)
Список 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 по дате отправления:

Предыдущее
От: Doug McNaught
Дата:
Сообщение: Re: Lack of use of indexes
Следующее
От: Felipe Schnack
Дата:
Сообщение: Re: EXECUTE problems