From: | "Volker Helm" <vhelm(at)shcom(dot)de> |
---|---|
To: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: I can't wait too much: Total runtime 432478.44 msec |
Date: | 2003-08-05 06:22:58 |
Message-ID: | FD7BCD54E00A5743BF3D411BE2D1885C113798@exchange.shcdom.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
Sorry Guy,
was just a little tired yesterday.
> Err... you're right... one of us say the same thing when I show the
> Volker mail...
Try to make a group by in the inline-view, so you will get something
like this:
>
> 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 id_instalacion,
id_contenido,
generar_vainilla,
max(cp1.fecha_publicacion) as max_pub
FROM cont_publicacion cp1
GROUP BY id_instalacion,id_contenido,generar_vainilla) a
where
...
AND a.id_instalacion = cont_publicacion.id_instalacion
AND a.id_contenido = cont_publicacion.id_contenido
AND a.generar_vainilla = cont_publicacion.generar_vainilla
AND a.max_pub = cont_publicacion.fecha_publicacion
Sorry for this missing group.
Bye,
Volker
From | Date | Subject | |
---|---|---|---|
Next Message | Ara Anjargolian | 2003-08-05 09:33:17 | query/table design help |
Previous Message | Manfred Koizar | 2003-08-04 23:36:27 | Re: I can't wait too much: Total runtime 432478.44 msec |