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
>
>