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

From: Manfred Koizar <mkoi-pg(at)aon(dot)at>
To: Manfred Koizar <mkoi-pg(at)aon(dot)at>
Cc: "Fernando Papa" <fpapa(at)claxson(dot)com>, <pgsql-performance(at)postgresql(dot)org>
Subject: Re: I can't wait too much: Total runtime 432478.44 msec
Date: 2003-08-04 23:36:27
Message-ID: 95rtivs8a4oqhc52ej0gq2k9o0c3nm29pl@4ax.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Volker Helm 2003-08-05 06:22:58 Re: I can't wait too much: Total runtime 432478.44 msec
Previous Message Jenny Zhang 2003-08-04 22:48:55 Re: [osdldbt-general] Re: [PERFORM] OSDL Database Test Suite 3 is