From: | Alvaro Herrera <alvherre(at)2ndquadrant(dot)com> |
---|---|
To: | Aland Laines <aland(dot)laines(at)gmail(dot)com> |
Cc: | Anthony Rafael Sotolongo León <asotolongo(at)uci(dot)cu>, Cesar Erices <caerices(at)gmail(dot)com>, POSTGRES <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | Re: Rehacer consulta |
Date: | 2014-02-05 20:36:40 |
Message-ID: | 20140205203640.GU10723@eldon.alvh.no-ip.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
Aland Laines escribió:
> Muchas gracias, me sirvió de mucho su ayuda, al final mi consulta quedo asi:
>
> SELECT
> date_part('YEAR',"Postulante".created) AS "Postulante__year",
> date_part('MONTH',"Postulante".created) AS "Postulante__month",
> SUM (CASE "Persona".genero WHEN 'M' THEN 1 ELSE 0 END) AS
> "Postulante__masculino",
> SUM (CASE "Persona".genero WHEN 'M' THEN 0 ELSE 1 END) AS
> "Postulante__femenino",
> count("Postulante".id) AS "Postulante__cantidad"
> FROM "produccion"."postulantes" AS "Postulante" LEFT JOIN
> "produccion"."personas" AS "Persona" ON ("Postulante"."persona_id" =
> "Persona"."id")
> WHERE "Postulante"."estado" = 1 AND date_part('YEAR',"Postulante".created)
> = '2013'
> GROUP BY date_part('YEAR',"Postulante"."created"),
> date_part('MONTH',"Postulante"."created")
> ORDER BY date_part('YEAR',"Postulante".created) ASC,
> date_part('MONTH',"Postulante".created) ASC;
¿cuál es la razón de usar aliases de tabla tan engorrosos que requieren
esparcir comillas por todas partes? Poniendo "FROM
produccion.postulantes AS p" simplificaría mucho la legibilidad de tu
consulta.
--
Álvaro Herrera http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
-
Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda(at)postgresql(dot)org)
Para cambiar tu suscripción:
http://www.postgresql.org/mailpref/pgsql-es-ayuda
From | Date | Subject | |
---|---|---|---|
Next Message | Jonathan Finlay | 2014-02-06 01:46:43 | could not serialize access due to concurrent update |
Previous Message | Anthony Rafael Sotolongo León | 2014-02-05 20:30:53 | Re: Rehacer consulta |