Re: Select distinct question ... complicated

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

johnl

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