Re: Formulating an sql query with CTID
От | Hannu Krosing |
---|---|
Тема | Re: Formulating an sql query with CTID |
Дата | |
Msg-id | 1154203006.2904.6.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: Formulating an sql query with CTID (Martijn van Oosterhout <kleptog@svana.org>) |
Список | pgsql-hackers |
Ühel kenal päeval, L, 2006-07-29 kell 18:25, kirjutas Martijn van Oosterhout: > On Sat, Jul 29, 2006 at 03:37:15AM +0300, 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. > > Use DISTINCT ON, see the docs for details. > > http://www.postgresql.org/docs/7.4/static/queries-select-lists.html > > That's for an older version, but it still works the same, google isn't > delivering the newer version... replace /7.4/ with /8.1/ to get a newer version ;) > Have an nice day, -- ---------------- Hannu Krosing Database Architect Skype Technologies OÜ Akadeemia tee 21 F, Tallinn, 12618, Estonia Skype me: callto:hkrosing Get Skype for free: http://www.skype.com
В списке pgsql-hackers по дате отправления: