Re: limit results to one row per foreign object

From: "Alan Bullock" <liststuff(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: limit results to one row per foreign object
Date: 2006-06-30 17:34:45
Message-ID: e83nbq$9es$1@sea.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Alan Bullock" <liststuff(at)gmail(dot)com> wrote in message
news:e83f29$dss$1(at)sea(dot)gmane(dot)org(dot)(dot)(dot)
> 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)

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthew Schumacher 2006-06-30 17:36:27 Re: pgsql vs mysql
Previous Message David Fetter 2006-06-30 17:30:37 Re: Notes on converting from MySQL 5.0.x to PostgreSQL