Postgres Pro
Downloads
Home   >   mailing lists

How to do this in PostgreSQL? - Mailing list pgsql-sql

From Robert Nosko
Subject How to do this in PostgreSQL?
Date
Msg-id NEBBLMLPILFNHKNECKIFIENOCAAA.robertn@eori.net.pl
Whole thread Raw
In response to Re: Function  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: How to do this in PostgreSQL?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: "Ingram, Bryan"
Date:
Subject: Threaded Records in SQL: Advice Needed
Next
From: "Patrick Giagnocavo"
Date:
Subject: Re: Threaded Records in SQL: Advice Needed