How to do this in postgtreSQL?

From: "Robert Nosko" <robertn(at)eori(dot)net(dot)pl>
To: <pgsql-general(at)postgresql(dot)org>, <pgsql-admin(at)postgresql(dot)org>, <pgsql-novice(at)postgresql(dot)org>
Subject: How to do this in postgtreSQL?
Date: 2000-04-11 02:39:34
Message-ID: NEBBLMLPILFNHKNECKIFMENOCAAA.robertn@eori.net.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Hi,

In ORACLE I can perform the following query:

SELECT tableA.id, title, qty
FROM tableA, (SELECT id, count(*) qty FROM tableB group by id) tableC
WHERE tableA.id = tableC.id (+)

but in PostgreSQL I get error message.
How can I perform it in Postgres?

thanks,
robert

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Cheng Ada 2000-04-11 08:53:46 Authentication Problem?
Previous Message Jason Maples 2000-04-10 19:24:17 Database Recovery

Browse pgsql-general by date

  From Date Subject
Next Message JB 2000-04-11 03:40:14 LIKE with spaces
Previous Message Ed Loehr 2000-04-10 23:47:25 Re: How big a database will PostgreSQL support?