The spec does require a FROM clause in SELECT (at least as of SQL99, did
not check SQL2003). However, it's clearly mighty useful to allow FROM
to be omitted for simple compute-this-scalar-result problems. You
should respond to the Oracle guy that SELECT whatever FROM dual is not
in the
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of
Greg Stark
Sent: Tuesday, June 13, 2006 11:16 PM
Subject: Re: [PERFORM] OT - select + must have from - sql
standard syntax?
[SNIP]
Well you could always create a dual, it was always just
Hi,
I don't have a copy of the standard on hand and a collegue is claiming
that there must be a from clause in a select query (he is an oracle
guy). This doesn't seem to be the case for postgres... does anyone
know?
Cheers
Antoine
ps. any one of them will do...
--
This is where I should put some
On Tue, Jun 13, 2006 at 02:43:45PM +0200, Antoine wrote:
Hi,
I don't have a copy of the standard on hand and a collegue is claiming
that there must be a from clause in a select query (he is an oracle
guy). This doesn't seem to be the case for postgres... does anyone
know?
Dunno, but I know
Jim C. Nasby [EMAIL PROTECTED] writes:
On Tue, Jun 13, 2006 at 02:43:45PM +0200, Antoine wrote:
I don't have a copy of the standard on hand and a collegue is claiming
that there must be a from clause in a select query (he is an oracle
guy). This doesn't seem to be the case for postgres... does
Tom Lane [EMAIL PROTECTED] writes:
The spec does require a FROM clause in SELECT (at least as of SQL99, did
not check SQL2003). However, it's clearly mighty useful to allow FROM
to be omitted for simple compute-this-scalar-result problems. You
should respond to the Oracle guy that SELECT