Justin Clift <[EMAIL PROTECTED]> 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
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
