Re: Select distinct question ... complicated

It's easier to create a simple pgsql function 
to do this ...

johnl

> -----Original Message-----
> From: pgsql-hackers-owner@postgresql.org
> [mailto:pgsql-hackers-owner@postgresql.org]On Behalf Of The Pennant Shop
> Sent: Wednesday, August 06, 2003 2:06 PM
> To: pgsql-hackers@postgresql.org
> 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