From: Hrishikesh Deshmukh <hdeshmuk@gmail.com>
To: pgsql-sql@postgresql.org
Subject: results being col wise rather than row wise
Date: Wed, 29 Mar 2006 20:08:51 -0500
Message-ID: <829d7fb60603291708k3449ce68j22ce498d05868e99@mail.gmail.com> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: hdeshmuk@gmail.com
Subject: Re: results being col wise rather than row wise
In-Reply-To: <829d7fb60603291708k3449ce68j22ce498d05868e99@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox