Postgres Pro
Downloads
Home   >   mailing lists

Re: limit results to one row per foreign object - Mailing list pgsql-general

From Alan Bullock
Subject Re: limit results to one row per foreign object
Date
Msg-id e83nbq$9es$1@sea.gmane.org
Whole thread Raw
In response to limit results to one row per foreign object  ("Alan Bullock" <liststuff@gmail.com>)
List pgsql-general
Tree view 
"Alan Bullock" <liststuff@gmail.com> wrote in message
news:e83f29$dss$1@sea.gmane.org...
> hi all, I have the following schema:
>
thanks all for such prompt replies! I'm going with Martijn's solution, I'm a
total newbie and it appears simplest (though I realise it's pgsql only)

pgsql-general by date:

Previous
From: David Fetter
Date:
Subject: Re: Notes on converting from MySQL 5.0.x to PostgreSQL
Next
From: Matthew Schumacher
Date:
Subject: Re: pgsql vs mysql