Fwd: Expresiones arbitrarias en GROUP BY

From: p valdes <p(dot)valdes334(at)gmail(dot)com>
To: Lista - PostgreSQL <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: Fwd: Expresiones arbitrarias en GROUP BY
Date: 2011-01-25 13:04:23
Message-ID: AANLkTi=JBsbH5LECu-C18pbGN62jaswHtsRTSU30Q8hu@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

SELECT vigo.puerto, avg(vigo.potencia)::int media FROM vigo WHERE
vigo.puerto::text = 'vigo'::text GROUP BY vigo.puerto union all select
'NO Vigo' puerto,sum(potencia)/count(potencia) media from vigo where
puerto !='vigo';

Saludetes
pvaldes

In response to

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message p valdes 2011-01-25 13:15:18 Re: Expresiones arbitrarias en GROUP BY
Previous Message Sergio Gabriel Rodriguez 2011-01-25 12:43:19 Re: could not receive data from client: Unknown winsock error 10061