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)
Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info
WARNING TO SPAMMERS: see at
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2006-07-29 01:17:06|
|Subject: Re: DTrace enabled build fails |
|Previous:||From: Bruce Momjian||Date: 2006-07-29 00:19:14|
|Subject: Re: pg_dump: add option to ignore TABLE DATA for failed|