reforming query for 7.0.2 - Mailing list pgsql-sql

From Markus Bertheau
Subject reforming query for 7.0.2
Date
Msg-id 1011187735.27679.11.camel@entwicklung01.cenes.de
Whole thread Raw
Responses Re: reforming query for 7.0.2
List pgsql-sql
Hello,

how do I reform this query to work with 7.0.2?


select * from personen join (select count(personen_id), personen_id from
orders group by personen_id) as ordertemp on personen.personen_id =
ordertemp.personen_id

If the table structure is needed I will happily post it here. Although I
don't think it is.

TIA

Markus Bertheau


pgsql-sql by date:

Previous
From: Jeff Boes
Date:
Subject: Re: Long-running DELETE
Next
From: "Glenn MacGregor"
Date:
Subject: limiting access to (through) views