Formulating an sql query with CTID

From: Tzahi Fadida <Tzahi(dot)ML(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Formulating an sql query with CTID
Date: 2006-07-29 00:37:15
Message-ID: 200607290337.15680.Tzahi.ML@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2006-07-29 01:17:06 Re: DTrace enabled build fails
Previous Message Bruce Momjian 2006-07-29 00:19:14 Re: pg_dump: add option to ignore TABLE DATA for failed