Wildcards in GROUP BY?
| От | Jon Lapham |
|---|---|
| Тема | Wildcards in GROUP BY? |
| Дата | |
| Msg-id | 3D1B6802.1050507@extracta.com.br обсуждение исходный текст |
| Список | pgsql-general |
Hello-
Is it possible to use wild cards in a GROUP BY statement?
ie: running the following query
SELECT a.*, COUNT(b.something)
FROM a, b
WHERE a.id=b.id
GROUP BY a.*;
returns the following message:
ERROR: parser: parse error at or near "*"
If you cannot use wildcards in GROUP BY statements, is the only solution
to expand "a.*" to all its constituent parts? Ugh.
main_v0_8=# select version();
version
-------------------------------------------------------------
PostgreSQL 7.2.1 on i686-pc-linux-gnu, compiled by GCC 2.96
(1 row)
Thanks, Jon
--
-**-*-*---*-*---*-*---*-----*-*-----*---*-*---*-----*-----*-*-----*---
Jon Lapham
Extracta Moléculas Naturais, Rio de Janeiro, Brasil
email: lapham@extracta.com.br web: http://www.extracta.com.br/
***-*--*----*-------*------------*--------------------*---------------
В списке pgsql-general по дате отправления: