On Fri, Mar 16, 2001 at 05:57:14PM -0500, Christopher Audley wrote:
> I'm trying to modify an application which runs on Oracle to run against
> PostgreSQL. I'm currently stuck on a query that I can't recognize, it
> doesn't look like standard SQL.
>
> A select is done across two tables, howeve
> A select is done across two tables, however when joining the foreign
> key, the right hand side of the equallity has (+) appended
>
> SELECT o.* from one o, two t where o.key = t.key(+)
>
> Does anyone know what this does and how I can reproduce the select in
> PostgreSQL?
Hi Chris,
The (+) in
This is Oracle's syntax for an outer join. Try this in PostgreSQL
SELECT o.* from one o LEFT JOIN two t ON o.key = t.key;
-Original Message-
From: Christopher Audley [SMTP:[EMAIL PROTECTED]]
Sent: Friday, March 16, 2001 3:57 PM
To: [EMAIL PROTECTED]
Subject:Oracle to Pos
I'm trying to modify an application which runs on Oracle to run against
PostgreSQL. I'm currently stuck on a query that I can't recognize, it
doesn't look like standard SQL.
A select is done across two tables, however when joining the foreign
key, the right hand side of the equallity has (+)
On Fri, Mar 16, 2001 at 12:15:28PM +, Egbert Ellenkamp wrote:
> All,
>
> Is there a way I can set the sequence of a table equal to highest row
> ID?
> For example something like:
> select setval('mytable_myrowid_seq',select max(myrowid) from mytable);
So close!
select setval('mytable_myrowi
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> As I said in my previous e-mail, I appear to have gotten the list to
> order itself by basing it on an (ordered) sub-select. Since the DB is
> only 50% populated right now, I'm not sure that's working perfectly but
> I'll keep you posted.
Yes, that oug
All,
Is there a way I can set the sequence of a table equal to highest row
ID?
For example something like:
select setval('mytable_myrowid_seq',select max(myrowid) from mytable);
I read the documentation but could not find anything relevant.
Thanks in advance,
Egbert.
-
Hello,
I would know if Postgres support SQL3 language. in
other word, does the pgsql conforme with sql3.
if yes wich version support this.
thank you.
Tom,
> Yes, that oughta work fine to determine the order of inputs to the
> aggregate function. ORDER BY in sub-selects is a new feature (heck,
> sub-selects in FROM at all is a new feature) in 7.1, so this trick
> wasn't available when Richard and I discussed the issue before.
Hey, why do you
Richard,
> Sorry - issue was to do with the ordering of the concatenation, not
> the
> user-defined aggregates (iirc - it's getting late here).
>
> I do remember I got different orders when selecting and updating. In
> my
> case it didn't matter, and I'm guessing if the order reverses in your
10 matches
Mail list logo
