How to do this in PostgreSQL?

From: "Robert Nosko" <robertn(at)eori(dot)net(dot)pl>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: How to do this in PostgreSQL?
Date: 2000-04-11 02:38:19
Message-ID: NEBBLMLPILFNHKNECKIFIENOCAAA.robertn@eori.net.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message mig 2000-04-11 13:01:41 Re: Threaded Records in SQL: Advice Needed
Previous Message Tom Lane 2000-04-11 01:04:30 Re: Using overlaps()