Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Aggregates
- From: Naz Gassiep <naz(at)mira(dot)net>
- To: pgsql-general(at)postgresql(dot)org
- Subject: Aggregates
- Date: Thu, 21 Jun 2007 13:01:42 +0200
- Message-id: <467A5A96(dot)8060009(at)mira(dot)net>
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.
- Follow-Ups:
- Re: Aggregates
- From: Richard Huxton
- Re: Aggregates
- Prev by Date: Re: Recovery/Restore and Roll Forward Question.
- Next by Date: Re: Accent insensitive search
- Previous by thread: 8.2.3 PANIC with "corrupted item pointer"
- Next by thread: Re: Aggregates
- Indexes: