From: | Justin Clift <jc(at)telstra(dot)net> |
---|---|
To: | Andreas Pflug <pgadmin(at)pse-consulting(dot)de> |
Cc: | PostgreSQL Development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: LinuxTag wrapup |
Date: | 2004-07-05 02:29:20 |
Message-ID: | 40E8BD00.1000704@telstra.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Andreas Pflug wrote:
<snip>
> That's true, it's the question how much can be offered without too much
> effort.
> I'm not too deep in oracle stuff, what comes to my mind is
> - outer join syntax (parser thing)
> - sequences usage (parser too)
> - maybe stored procedure call, with a wrapper to convert output
> parameters to a composite return value.
There's also their "FROM DUAL" workaround (in common usage) as well.
i.e. SELECT NEXTVAL.foo FROM DUAL;
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.
Regards and best wishes,
Justin Clift
> There's certainly no point supporting any weird ddl command, so there's
> still porting work to be done when migrating.
>
> Regards,
> Andreas
From | Date | Subject | |
---|---|---|---|
Next Message | elein | 2004-07-05 02:39:19 | plperl, cvs head w/spi patch, return rows on update returns nothing (resend) |
Previous Message | Bruce Momjian | 2004-07-05 02:18:04 | Re: [HACKERS] Compile failure in plperl |