Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id DECF46327B9
	for <pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 20 Aug 2009 09:14:18 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 37399-03 for
	<pgsql-sql-postgresql.org@mail.postgresql.org>;
	Thu, 20 Aug 2009 12:14:08 +0000 (UTC)
X-Greylist: delayed 00:06:49.408144 by SQLgrey-1.7.6
Received: from mail-px0-f180.google.com (mail-px0-f180.google.com
	[209.85.216.180])
	by mail.postgresql.org (Postfix) with ESMTP id 7CBDC6325F1
	for <pgsql-sql@postgresql.org>; Thu, 20 Aug 2009 09:14:08 -0300 (ADT)
Received: by pxi10 with SMTP id 10so3418678pxi.28
	for <pgsql-sql@postgresql.org>; Thu, 20 Aug 2009 05:14:06 -0700 (PDT)
MIME-Version: 1.0
Received: by 10.142.209.20 with SMTP id h20mr1491745wfg.36.1250770035839;
 Thu,
	20 Aug 2009 05:07:15 -0700 (PDT)
X-Originating-IP: [74.239.167.171]
Date: Thu, 20 Aug 2009 08:07:15 -0400
Message-ID: <cfbfcf160908200507q422601c2r3950f5db8a102587@mail.gmail.com>
Subject: Advice returning data as an array
From: George Woodring <george.woodring@iglass.net>
To: pgsql-sql@postgresql.org
Content-Type: multipart/alternative; boundary=000e0cd32e2eae923604719197cf
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-0.739 tagged_above=-10 required=5
	tests=BAYES_20=-0.74, HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200908/111
X-Sequence-Number: 33020

--000e0cd32e2eae923604719197cf
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit

I have the following query that works the way I need:
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

--000e0cd32e2eae923604719197cf
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

I have the following query that works the way I need:<div><br></div><div>SE=
LECT &#39;20090812&#39; AS date, sum(in_oct) AS bytes, sum(in_pkt) AS pkts,=
 &#39;appl&#39; AS name, ARRAY[&#39;appl&#39;] AS fields, CAST((LEAST(src_p=
ort, dst_port)) AS varchar) as fieldVal FROM flow_history.flows_20090812 GR=
OUP BY fieldVal ORDER BY bytes DESC LIMIT 20;</div>

<div><br></div><div>My issue is that I need to get the fieldVal =A0to retur=
n as an array and be fieldVal[1]. =A0Any suggestions?</div><div><br></div><=
div>Thanks,</div><div>Woody<br clear=3D"all"><br>-- <br>iGLASS Networks<br>=
<a href=3D"http://www.iglass.net" target=3D"_blank">www.iglass.net</a><br>


</div>

--000e0cd32e2eae923604719197cf--