Postgres Pro
Downloads
Home   >   mailing lists

Re: combining records from a single table and presenting them as one record - Mailing list pgsql-sql

From Michael Fuhr
Subject Re: combining records from a single table and presenting them as one record
Date
Msg-id 20051028171259.GA45089@winnie.fuhr.org
Whole thread Raw
In response to Re: combining records from a single table and presenting them as one record  (Abhishek <ajcool@gmail.com>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Muralidharan Ramakrishnan
Date:
Subject: Re: Complex Query - Data from 3 tables simultaneously
Next
From: Kyle Bateman
Date:
Subject: information_schema problem