Re: I can't wait too much: Total runtime 432478.44 msec - Mailing list pgsql-performance

From Manfred Koizar
Subject Re: I can't wait too much: Total runtime 432478.44 msec
Date
Msg-id 95rtivs8a4oqhc52ej0gq2k9o0c3nm29pl@4ax.com
Whole thread Raw
In response to Re: I can't wait too much: Total runtime 432478.44 msec  (Manfred Koizar <mkoi-pg@aon.at>)
List pgsql-performance
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

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: [osdldbt-general] Re: OSDL Database Test Suite 3 is
Next
From: "Volker Helm"
Date:
Subject: Re: I can't wait too much: Total runtime 432478.44 msec