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

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Stefan Keller <sfkeller(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: "SELECT ... FROM DUAL" is not quite as silly as it appears
Date: 2019-01-28 09:31:28
Message-ID: e81423dd4403ae6e9ea5c35b4e109630d8531830.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Etsuro Fujita 2019-01-28 10:37:48 Re: postgres_fdw: estimate_path_cost_size fails to re-use cached costs
Previous Message Michael Paquier 2019-01-28 09:25:10 Re: pg_basebackup, walreceiver and wal_sender_timeout