Advice returning data as an array - Mailing list pgsql-sql

SELECT '20090812' AS date, sum(in_oct) AS bytes, sum(in_pkt) AS pkts, 'appl' AS name, ARRAY['appl'] AS fields, CAST((LEAST(src_port, dst_port)) AS varchar) as fieldVal FROM flow_history.flows_20090812 GROUP BY fieldVal ORDER BY bytes DESC LIMIT 20;

My issue is that I need to get the fieldVal  to return as an array and be fieldVal[1].  Any suggestions?

Thanks,

Woody

--
iGLASS Networks
www.iglass.net