Aggregates - Mailing list pgsql-general

From Naz Gassiep
Subject Aggregates
Date
Msg-id 467A5A96.8060009@mira.net
Whole thread Raw
Responses Re: Aggregates  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Hi,
    If I have a table with users and a table with messages, is it
possible to have a query that returns user.* as well as one extra column
with the number of messages they have posted and the data and time of
the last message? At the moment I am using a subquery to do this,
however it seems suboptimal. Is there a better way?
- Naz.

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: Recovery/Restore and Roll Forward Question.
Next
From: Gregory Stark
Date:
Subject: Re: Accent insensitive search