[SQL] combining records from a single table and presenting them as one record

desired result with no duplication. But 'distinct' seems to be too expensive.   Is there any better way I can do this without compromising the performance ?   Your suggestions and input are very appreciated   Thanks AJ   -- Abhishek Jain 

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

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. :-( On 10/27/05, boinger <[EMAIL PROTECTED]> wrote: On 10/27/05, Abhishek &

Re: [SQL] Using EXPLAIN-ANALYZE

http://www.postgresql.org/docs/7.2/static/performance-tips.html   EXPLAIN is explaied quite nicely with examples here. Hope that helps   Bests AJ  On 2/16/06, Kashmira Patel (kupatel) <[EMAIL PROTECTED]> wrote: Hi all,    I am pretty new to using Postrgres, and have been looking at the messages in