Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
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)

Tzahi Fadida
Blog: | Home Site:


pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group