| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
| Cc: | felipe fernandez <ffdezrguez(at)gmail(dot)com>, Ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: Group by de mysql a postgresql |
| Date: | 2011-11-18 14:15:51 |
| Message-ID: | CAJKUy5j7ZffT+S_DCLPDHLuPnLigPY4fj85cZTDUB-DoY1amCw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
2011/11/18 Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org>:
>
> No recuerdo en qué versión se agregó esta característica.
>
http://www.postgresql.org/docs/9.1/static/release-9-1.html
"""
- Allow non-GROUP BY columns in the query target list when the primary
key is specified in the GROUP BY clause (Peter Eisentraut)
The SQL standard allows this behavior, and because of the primary key,
the result is unambiguous.
"""
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte 24x7 y capacitación
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jose David Verbel Tous | 2011-11-18 15:35:58 | Re: Consultar Tablas Hija |
| Previous Message | Alejandro Carrillo | 2011-11-18 14:02:15 | Rv: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] [OT] Integración PostgreSQL Latinas |