From: | Tzahi Fadida <Tzahi(dot)ML(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Formulating an sql query with CTID |
Date: | 2006-07-29 10:37:44 |
Message-ID: | 200607291337.45131.Tzahi.ML@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
10x,
Found my answer thanks to Ragnar.
SELECT DISTINCT ON (a0,a1) a0,a1,ctid FROM t1
To tell the truth, i did not know there was an ON option in SQL.
This thing is very handy.
On Saturday 29 July 2006 03:37, Tzahi Fadida wrote:
> 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
From | Date | Subject | |
---|---|---|---|
Next Message | korryd@enterprisedb.com | 2006-07-29 12:18:33 | Re: [HACKERS] Possible explanation for Win32 stats regression test |
Previous Message | Joe Conway | 2006-07-29 06:50:05 | Re: [HACKERS] 8.2 features? |