Re: I can't wait too much: Total runtime 432478.44 msec

Err... you're right... one of us say the same thing when I show the
Volker mail...

-----Mensaje original-----
De: Manfred Koizar [mailto:mkoi-pg(at)aon(dot)at]
Enviado el: lunes, 04 de agosto de 2003 12:17
Para: Fernando Papa
CC: Volker Helm; pgsql-performance(at)postgresql(dot)org
Asunto: Re: [PERFORM] I can't wait too much: Total runtime 432478.44
msec

On Mon, 4 Aug 2003 12:02:46 -0300, "Fernando Papa" <fpapa(at)claxson(dot)com>
wrote:
> FROM
> cont_contenido
> ,juegos_config
> ,cont_publicacion
> ,(SELECT max(cp1.fecha_publicacion) as max_pub
--change here
> FROM cont_publicacion cp1) a --change here

But this calculates the global maximum, not per id_instalacion,
id_contenido, and generar_vainilla as in

> AND cont_publicacion.fecha_publicacion = (SELECT
max(cp1.fecha_publicacion)
> FROM cont_publicacion cp1
> WHERE cp1.id_instalacion =
cont_publicacion.id_instalacion
> AND cp1.id_contenido =
cont_publicacion.id_contenido
> AND cp1.generar_vainilla =
cont_publicacion.generar_vainilla)

Servus
Manfred