Mike Fowler <m...@mlfowler.com> wrote:
 
> SELECT 1,null,null
> UNION
> SELECT 2,3,null
> UNION
> SELECT 3,null,4
 
> In Oracle I get a delicious error message:
> 
> Error: ORA-00923: FROM keyword not found where expected
 
For Oracle, shouldn't that be:
 
SELECT 1,null,null FROM DUAL
UNION
SELECT 2,3,null FROM DUAL
UNION
SELECT 3,null,4 FROM DUAL
 
-Kevin

-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to