Re: LinuxTag wrapup

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

In response to

Responses

Browse pgsql-hackers by date

  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