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 по дате отправления:

Предыдущее
От: Christopher Murtagh
Дата:
Сообщение: Permissions question
Следующее
От: "Glen Parker"
Дата:
Сообщение: Re: Shared Memory Sizing