Re: "SELECT ... FROM DUAL" is not quite as silly as it appears

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: "SELECT ... FROM DUAL" is not quite as silly as it appears
Дата
Msg-id 31228.1547511444@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: "SELECT ... FROM DUAL" is not quite as silly as it appears  (David Rowley <david.rowley@2ndquadrant.com>)
Ответы Re: "SELECT ... FROM DUAL" is not quite as silly as it appears  (David Rowley <david.rowley@2ndquadrant.com>)
Re: "SELECT ... FROM DUAL" is not quite as silly as it appears  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
David Rowley <david.rowley@2ndquadrant.com> writes:
> 1. I don't think having a table named "dual" makes a whole lot of
> sense for a table with a single row.

Well, I borrowed Oracle terminology there ;-)

> (Uppercasing these additions would also make them look less of an afterthought.)

Don't really care, can do.

> I also did a quick benchmark of v6 and found the slowdown to be
> smaller after the change made in build_simple_rel()

Thanks for confirming.  I was not very sure that was worth the extra
few bytes of code space, but if you see a difference too, then it's
probably worthwhile.

            regards, tom lane


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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: "SELECT ... FROM DUAL" is not quite as silly as it appears
Следующее
От: Amit Langote
Дата:
Сообщение: Re: [Sender Address Forgery]Re: error message when subscriptiontarget is a partitioned table