X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by postgresql.org (Postfix) with ESMTP id 3756211F661D
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 29 Mar 2006 21:08:57 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 87309-04
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 29 Mar 2006 21:08:54 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-
Received: from nproxy.gmail.com (nproxy.gmail.com [64.233.182.204])
	by postgresql.org (Postfix) with ESMTP id F151C11F653B
	for <pgsql-sql@postgresql.org>; Wed, 29 Mar 2006 21:08:51 -0400 (AST)
Received: by nproxy.gmail.com with SMTP id l24so222032nfc
	for <pgsql-sql@postgresql.org>; Wed, 29 Mar 2006 17:08:51 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=TBakZzrlcsYA+o6v870gt3XRoxPR0/mfSHIIEeXD60GTf1AuTT6LAVuel6sNZlaPp1+SitPpDF7GMc6OEyapGcDIjyC0EvHivnP+axUTFWIB1CZDPj02Ig/hsDbYAo4lOSwtIA1DS7Fs+H7t6corFWQJW4XPHgKtXD5iVzytw9M=
Received: by 10.48.223.16 with SMTP id v16mr676686nfg;
	Wed, 29 Mar 2006 17:08:51 -0800 (PST)
Received: by 10.48.209.16 with HTTP; Wed, 29 Mar 2006 17:08:51 -0800 (PST)
Message-ID: <829d7fb60603291708k3449ce68j22ce498d05868e99@mail.gmail.com>
Date: Wed, 29 Mar 2006 20:08:51 -0500
From: "Hrishikesh Deshmukh" <hdeshmuk@gmail.com>
To: pgsql-sql@postgresql.org
Subject: results being col wise rather than row wise
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_10304_16106363.1143680931583"
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, score=0.554 required=5 tests=[AWL=0.553,
 HTML_MESSAGE=0.001]
X-Spam-Score: 0.554
X-Spam-Level: 
X-Archive-Number: 200603/457
X-Sequence-Number: 24803

------=_Part_10304_16106363.1143680931583
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

HI All,

I have 5 tables which have different columns as shown below, each table has
a different case column,
i want to retrieve sample related information as follows:

pid | xindex | yindex | height Index | flag | case1 | case 2.....etc

But i get this queer result:
pid        | xindex | yindex | Height Index | flag |     case
-------------+--------+--------+-------------+-------------+---------
102234   |    411 |    271 |           9 |           1 |      80
102234   |    411 |    271 |           9 |           1 |      83
102234   |    411 |    271 |           9 |           1 |      87
102234   |    411 |    271 |           9 |           1 |     101
102234   |    411 |    271 |           9 |           1 |     129
102234   |    411 |    271 |           9 |           1 |      91
102234   |    411 |    271 |           9 |           1 |   120.3

Why is the result in a column wise rather than row wise???!!!!
Could somebody explain why the redundancy with respect to pi, xindex,
yindex, height index, flag but the CORRECT values for the cases but not in
the order expected!!!


Thanks,
Hrishi

------=_Part_10304_16106363.1143680931583
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

HI All,<br>
<br>
I have 5 tables which have different columns as shown below, each table has=
 a different case column,<br>
i want to retrieve sample related information as follows:<br>
<br>
pid | xindex | yindex | height Index | flag | case1 | case 2.....etc<br>
<br>
But i get this queer result:<br>
<font face=3D"Courier New,Courier,mono">pid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp; | xindex | yindex | Height Index | flag | &nbsp; &nbsp; case<br>=
-------------+--------+--------+-------------+-------------+---------<br>10=
2234
&nbsp; |&nbsp;&nbsp;&nbsp; 411 |&nbsp;&nbsp;&nbsp; 271
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80<br>102234 &nbsp; |&nbsp;&nbsp;&nbsp;
411 |&nbsp;&nbsp;&nbsp; 271
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 83<br>102234 &nbsp; |&nbsp;&nbsp;&nbsp;
411 |&nbsp;&nbsp;&nbsp; 271
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 87<br>102234 &nbsp; |&nbsp;&nbsp;&nbsp;
411 |&nbsp;&nbsp;&nbsp; 271
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1
|&nbsp;&nbsp;&nbsp;&nbsp; 101<br>102234 &nbsp; |&nbsp;&nbsp;&nbsp; 411
|&nbsp;&nbsp;&nbsp; 271
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1
|&nbsp;&nbsp;&nbsp;&nbsp; 129<br>102234 &nbsp; |&nbsp;&nbsp;&nbsp; 411
|&nbsp;&nbsp;&nbsp; 271
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 91<br>102234 &nbsp; |&nbsp;&nbsp;&nbsp;
411 |&nbsp;&nbsp;&nbsp; 271
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 9
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1
|&nbsp;&nbsp; 120.3<br>
<br>
Why is the result in a column wise rather than row wise???!!!!<br>
Could somebody explain why the redundancy with respect to pi, xindex,
yindex, height index, flag but the CORRECT values for the cases but not
in the order expected!!!<br>
<br>
<br>
Thanks,<br>
Hrishi<br>
</font>

------=_Part_10304_16106363.1143680931583--