Re: LinuxTag wrapup

Justin Clift <jc@telstra.net> writes:
> There's also their "FROM DUAL" workaround (in common usage) as well.

[ yawn... ]

regression=# create table dual();
CREATE TABLE
regression=# insert into dual default values;  
INSERT 292940 1
regression=# select 2+2 from dual;
 ?column? 
----------
        4
(1 row)

Anyone who needs this has always been able to make it trivially
(though you once had to invent a random column name for the one
required column).

Does anyone have the foggiest idea why they named it DUAL?  Doesn't
seem a very mnemonic choice to me...

			regards, tom lane