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