Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WQHxQ-0005Fd-1U for pgsql-sql@arkaria.postgresql.org; Wed, 19 Mar 2014 14:59:04 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1WQHxP-0002h8-IA for pgsql-sql@arkaria.postgresql.org; Wed, 19 Mar 2014 14:59:03 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WQHxO-0002h2-Ol for pgsql-sql@postgresql.org; Wed, 19 Mar 2014 14:59:02 +0000 Received: from dub0-omc2-s24.dub0.hotmail.com ([157.55.1.163]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1WQHxL-0004uz-0i for pgsql-sql@postgresql.org; Wed, 19 Mar 2014 14:59:02 +0000 Received: from DUB115-W133 ([157.55.1.136]) by dub0-omc2-s24.dub0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Wed, 19 Mar 2014 07:58:57 -0700 X-TMN: [3vuOn0ZsyuDoCtHB7etr7yjsoYL2sG6i] X-Originating-Email: [niftyshellsuit@outlook.com] Message-ID: Content-Type: multipart/alternative; boundary="_d0cc8a47-ff63-43ce-853a-190bb92f3ad2_" From: Jennifer Mackown To: "pgsql-sql@postgresql.org" Subject: Table results format - should I use crosstab? If so, how? Date: Wed, 19 Mar 2014 14:58:57 +0000 Importance: Normal MIME-Version: 1.0 X-OriginalArrivalTime: 19 Mar 2014 14:58:57.0538 (UTC) FILETIME=[C108A620:01CF4383] X-Pg-Spam-Score: 0.8 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-sql Precedence: bulk Sender: pgsql-sql-owner@postgresql.org --_d0cc8a47-ff63-43ce-853a-190bb92f3ad2_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi=2C=20 I have a problem with getting a table to display in the way I want it to. I= t's one of those things that looks so simple I should be able to do it in 5= minutes=2C but I've been working on it all afternoon and I'm getting nowhe= re!! What I have is the following: Date Firstday Lastday2014/03/12 1 12= 014/03/18 1 02014/03/19 0 12014= /03/21 1 1 And what I need to see is this: Firstday Lastday2014/03/12 2013/03/122014/03/18 201= 3/03/192014/03/21 2013/03/21 Can anyone help? Thanks=2C=20 Jennifer = --_d0cc8a47-ff63-43ce-853a-190bb92f3ad2_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi=2C =3B

I have a problem with getting a table to display in the way I w= ant it to. It's one of those things that looks so simple I should be able t= o do it in 5 minutes=2C but I've been working on it all afternoon and I'm g= etting nowhere!!

What I have is the following:

Date =3B =3B =3B =3B =3B &nb= sp=3B =3B Firstday =3B =3BLastday

2014/03/12 = =3B =3B =3B =3B1 =3B =3B =3B =3B = =3B =3B =3B =3B1

2014/03/18 =3B =3B &nbs= p=3B =3B1 =3B =3B =3B =3B =3B =3B = =3B =3B0

2014/03/19 =3B =3B =3B =3B0 &nb= sp=3B =3B =3B =3B =3B =3B =3B =3B1

2014/03/21 =3B =3B =3B =3B1 =3B =3B &nbs= p=3B =3B =3B =3B =3B =3B1

And what I need to see is this:

Fi= rstday =3B =3B =3B =3B =3B =3B Lastday

<= div>2014/03/12 =3B =3B =3B 2013/03/12

2014/03/18 &= nbsp=3B =3B =3B 2013/03/19

2014/03/21 =3B =3B= =3B 2013/03/21

Can anyone help?

Thanks=2C =3B

Jennifer =3B

= --_d0cc8a47-ff63-43ce-853a-190bb92f3ad2_--