Arrays and count ()
От | Mr M Pacey |
---|---|
Тема | Arrays and count () |
Дата | |
Msg-id | 3725C034.7DFF@liverpool.ac.uk обсуждение исходный текст |
Список | pgsql-sql |
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. P.S. Please cc any reply directly to me, as I'm not currently subbed to the list.
В списке pgsql-sql по дате отправления: