Re: INSERT ... ON CONFLICT syntax issues

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: INSERT ... ON CONFLICT syntax issues
Дата
Msg-id 20150428144415.GE19123@awork2.anarazel.de
обсуждение исходный текст
Ответ на Re: INSERT ... ON CONFLICT syntax issues  (Stephen Frost <sfrost@snowman.net>)
Ответы Re: INSERT ... ON CONFLICT syntax issues  (Stephen Frost <sfrost@snowman.net>)
Re: INSERT ... ON CONFLICT syntax issues  (Petr Jelinek <petr@2ndquadrant.com>)
Список pgsql-hackers
On 2015-04-28 10:40:10 -0400, Stephen Frost wrote:
> * Andres Freund (andres@anarazel.de) wrote:
> > On 2015-04-28 16:36:28 +0200, Petr Jelinek wrote:
> > > I am also very sure that every time I'll write this statement I will have to
> > > look into manual for the names of TARGET and EXCLUDED because they don't
> > > seem intuitive to me at all (especially the EXCLUDED).
> > 
> > Same here. I don't understand why 'CONFLICTING' would be more ambiguous
> > than EXCLUDED (as Peter argued earlier). Especially given that the whole
> > syntax is called ON CONFLICT.
> 
> Any way we can alias it?  Both of those strike me as annoyingly long and
> if we could allow an alias then people can do whatever they want...
> 
> No, I haven't got any suggestion on how to do that. :)
> 
> It's also something we can probably improve on in the future...

I earlier suggested NEW/OLD. I still think that's not too bad as I don't
buy the argument that they're too associated with rules.

Greetings,

Andres Freund



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

Предыдущее
От: Stephen Frost
Дата:
Сообщение: Re: INSERT ... ON CONFLICT syntax issues
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: INSERT ... ON CONFLICT syntax issues