Re: LinuxTag wrapup

Justin Clift <jc@telstra.net>

From: Justin Clift <jc@telstra.net>
To: Mario Weilguni <mweilguni@sime.com>
Cc: PostgreSQL Development <pgsql-hackers@postgresql.org>
Date: 2004-07-05T06:23:22Z
Lists: pgsql-hackers
Mario Weilguni wrote:
>>Because their SQL queries always seem to need a target object to select 
>>from.  i.e. "SELECT NEXTVAL.foo" isn't valid for Oracle 8/9.
<snip>
> It has been a long time since I've used Oracle, but shouldn't it be "select foo.nextval from dual"?

Yep, that's sounds better.  It's been a couple of months since I was 
writing SQL in Oracle.  Previous contract.

:)

Regards and best wishes,

Justin Clift


> Regards,
> 	Mario Weilguni
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
>       subscribe-nomail command to majordomo@postgresql.org so that your
>       message can get through to the mailing list cleanly
> 
>