It's easier to create a simple pgsql function to do this ... johnl
> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Behalf Of The Pennant Shop > Sent: Wednesday, August 06, 2003 2:06 PM > To: [EMAIL PROTECTED] > Subject: [HACKERS] Select distinct question ... complicated > > > Hi , > > I have a table: > item location > aaa 10 > aaa 20 > bbb 10 > bbb 10 > ccc 10 > ccc 20 > > I need to select distinct items where locations are > the same. So result set should look like: > item loation > bbb 10 > Already spent 7 hours on this one. > > Thanks a lot / Alex > > > > __________________________________ > Do you Yahoo!? > Yahoo! SiteBuilder - Free, easy-to-use web site design software > http://sitebuilder.yahoo.com > > ---------------------------(end of broadcast)--------------------------- > TIP 8: explain analyze is your friend ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
