Re: patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)

Поиск
Список
Период
Сортировка
От Pavlo Baron
Тема Re: patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)
Дата
Msg-id 00dd01c18f16$5456c630$6500a8c0@bw1
обсуждение исходный текст
Ответ на patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)  ("Pavlo Baron" <pb@pbit.org>)
Ответы Re: patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Re: patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
here is a new patch containing all changes you (Tom) suggested to make. I
still use my "pavlo (pbpbit.org)" for me to locate my code; feel free to
illiminate them before integrating :-)

Tom Lane:
> This would break
> INSERT INTO foo(textcolumn) VALUES ('@default')
> which I find hardly acceptable.
>
> The only way to do it without breaking valid data entries is to
> introduce a new parse node type to represent a DEFAULT placeholder.

Now there is a newly declared parse node type "Default" - the corresponding
structure has no data. The "@default" hack is now illiminated - I'm the
happiest about it

Tom Lane:
>
> I also wonder what's going to happen if I write DEFAULT in a SELECT's
> targetlist, which is possible given where you made the grammar change.

The grammer now contains two new rules: "insert_target_list" and
"insert_target_el", the SELECT and INSERT don't use the same targetlist
anymore, but the "insert_target_el" completely inherits "target_el" to avoid
multiple declarations and  it just provides the new DEFAULT-rule.

I hope, this patch is ok - to me, it looks correct now

rgds
Pavlo Baron


В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Pavlo Baron"
Дата:
Сообщение: Re: patch: INSERT INTO t VALUES (a, b, ..., DEFAULT, ...)
Следующее
От: "Pavlo Baron"
Дата:
Сообщение: TODO question