Re: combining records from a single table and presenting them as one record

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Abhishek <ajcool(at)gmail(dot)com>
Cc: boinger <boinger(at)gmail(dot)com>, pgsql-sql(at)postgresql(dot)org
Subject: Re: combining records from a single table and presenting them as one record
Date: 2005-10-28 17:12:59
Message-ID: 20051028171259.GA45089@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Oct 28, 2005 at 11:47:12AM -0400, Abhishek wrote:
> Using LIMIT 1 does return me a single record but please note that the table
> can have multiple guids for which I need a unique record with all the digit
> types combined. Using LIMIT 1 returns me always one record. :-(

Have you looked at contrib/tablefunc?

--
Michael Fuhr

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jason Turner 2005-10-28 21:30:55 Changing location of ORDER BY has large effect on performance, but not results...
Previous Message Muralidharan Ramakrishnan 2005-10-28 17:10:35 Re: Complex Query - Data from 3 tables simultaneously