Re: SET TRANSACTION and SQL Standard

Поиск
Список
Период
Сортировка
Искать
От
Tom Lane
Тема
Re: SET TRANSACTION and SQL Standard
Дата
Msg-id
197.1231773186@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
SET TRANSACTION and SQL Standard Simon Riggs <simon@2ndQuadrant.com>
Re: SET TRANSACTION and SQL Standard Peter Eisentraut <peter_e@gmx.net>
Re: SET TRANSACTION and SQL Standard Simon Riggs <simon@2ndQuadrant.com>
Re: SET TRANSACTION and SQL Standard Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>
Re: SET TRANSACTION and SQL Standard Simon Riggs <simon@2ndQuadrant.com>
Re: SET TRANSACTION and SQL Standard Tom Lane <tgl@sss.pgh.pa.us>
Re: SET TRANSACTION and SQL Standard Simon Riggs <simon@2ndQuadrant.com>
Re: SET TRANSACTION and SQL Standard Bruce Momjian <bruce@momjian.us>
Re: SET TRANSACTION and SQL Standard Tom Lane <tgl@sss.pgh.pa.us>
Re: SET TRANSACTION and SQL Standard Peter Eisentraut <peter_e@gmx.net>
Re: SET TRANSACTION and SQL Standard Tom Lane <tgl@sss.pgh.pa.us>
Peter Eisentraut  writes:
> I think this might be best solved by providing a common function that 
> checks a DefElem list for duplicates.  This could be used in a number of 
> other places as well (grep for "conflicting or redundant options").

It's not clear what that would save exactly.  The common coding pattern
intermixes this test with collection of the individual values for
subsequent processing, and you'd still have to do the latter.  It also
seems likely that a generic check of this form would be O(N^2) replacing
code that is currently O(N).  (I grant that N is usually too small for
it to matter ... but I'm not sure that's always true.)
		regards, tom lane

В списке pgsql-hackers по дате отправления
От: Peter Eisentraut
Дата:
От: Peter Eisentraut
Дата:
FAQ