Arrays and count()

Поиск
Список
Период
Сортировка
Искать
От
Mr M Pacey
Тема
Arrays and count()
Дата
Msg-id
3725C3E8.18B0@liverpool.ac.uk
Список
Дерево обсуждения
Arrays and count() Mr M Pacey <M.Pacey@liverpool.ac.uk>
Re: [SQL] Arrays and count() Tom Lane <tgl@sss.pgh.pa.us>
I'm having difficulties formulating what I thought was a simple
query in 6.3.2. I have a table defined like this:

create table sentence
( typenum int4, wordpos int4, words text[], tags  text[]
);

What I'd like to do is, e.g. select all instances of tags[1] and
display the frequency values for each unique (distinct) entry.
The query I tried was:

select sentence.tags[1], count (*) from sentence group by
sentence.tags[1];

Which fails to parse. Trying to work backwards I try constructing a
related command:

select count (sentence.tags[1]) from sentence;

And am treated to the error message:

PQexec() -- Request was sent to backend, but backend closed the channel
before responding.       This probably means the backend terminated abnormally before or
while processing the request.

Is this a bug, or am I completely failing to understand one or more
of the concepts involved here?

Mike Pacey.

В списке pgsql-sql по дате отправления
От: Mr M Pacey
Дата:
Сообщение: Arrays and count ()
От: Michael J Davis
Дата:
Сообщение: RE: [SQL] substring
FAQ