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
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
