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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: "SELECT ... FROM DUAL" is not quite as silly as it appears
Дата
Msg-id e81423dd4403ae6e9ea5c35b4e109630d8531830.camel@cybertec.at
обсуждение исходный текст
Ответ на Re: "SELECT ... FROM DUAL" is not quite as silly as it appears  (Stefan Keller <sfkeller@gmail.com>)
Ответы Re: "SELECT ... FROM DUAL" is not quite as silly as it appears  (David Rowley <david.rowley@2ndquadrant.com>)
Список pgsql-hackers
Stefan Keller wrote:
> Pls. try to give DUAL a better name, since it's IMHO neither
> self-explaining nor correct.

I agree with the sentiment.
On the other hand, people who migrate from Oracle might be happy if
there is a DUAL table that allows them to migrate some of their
statements unmodified.

I don't know if that is a good enough argument, though. 
Currently there is "orafce" which provides DUAL, and it might be
good enough if it defines DUAL as a view on DUMMY.

Yours,
Laurenz Albe



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: pg_basebackup, walreceiver and wal_sender_timeout
Следующее
От: Etsuro Fujita
Дата:
Сообщение: Re: postgres_fdw: estimate_path_cost_size fails to re-use cachedcosts