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