Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group