Formulating an sql query with CTID - Mailing list pgsql-hackers

From Tzahi Fadida
Subject Formulating an sql query with CTID
Date
Msg-id 200607290337.15680.Tzahi.ML@gmail.com
Whole thread Raw
Responses Re: Formulating an sql query with CTID
Re: Formulating an sql query with CTID
List pgsql-hackers
Hi,
I have a query i am having trouble to formulate:
I used to do:
SELECT DISTINCT a0,a1 FROM public.t1
However, now i need to add the CTID attribute, but CTID is unique
thus, distinct is useless. In addition, i can't seem to be able to use max()
etc... or casting to anything on CTID in order to use group by technique.

What are my options?

(I am using 8.2 or 8.1)

--
Regards,
        Tzahi.
--
Tzahi Fadida
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS:  see at
http://members.lycos.co.uk/my2nis/spamwarning.html


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pg_dump: add option to ignore TABLE DATA for failed
Next
From: Tom Lane
Date:
Subject: Re: DTrace enabled build fails