On Mon, 04 Aug 2003 16:10:18 +0200, I wrote: >SELECT DISTINCT ON ( > cp.id_instalacion, > cp.id_contenido, > cp.generar_vainilla, > cp.fecha_publicacion > )
Cut'n'paste error! fecha_publicacion should not be in the DISTINCT ON
list. The same error is in my second suggestion (FROM (subselect)).
Servus
Manfred
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
