Paul,
> select count(*),msg_text from msg_table where msg_text like '%PIX-1%'
> COUNT => '50' group by msg_text order by count desc;
>
> Is that possible in PostgreSQL?
Yes. You need an "intro to SQL" book to help you with this sort of thing;
consider "SQL Queries for Mere Mortals".
SELECT count(*) as no_msg, msg_text FROM msg_table
WHERE msg_text LIKE '%PIX-1%'
GROUP BY msg_text
HAVING count(*) >= 50
ORDER BY no_msg DESC;
--
-Josh Berkus
Aglio Database Solutions
San Francisco
