pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedresults being col wise rather than row wise
2+ messages / 2 participants
[nested] [flat]
* results being col wise rather than row wise
@ 2006-03-30 01:08 Hrishikesh Deshmukh <hdeshmuk@gmail.com>
0 siblings, 1 reply; 2+ messages in thread
From: Hrishikesh Deshmukh @ 2006-03-30 01:08 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: results being col wise rather than row wise
@ 2006-03-30 01:23 Stephan Szabo <sszabo@megazone.bigpanda.com>
parent: Hrishikesh Deshmukh <hdeshmuk@gmail.com>
0 siblings, 0 replies; 2+ messages in thread
From: Stephan Szabo @ 2006-03-30 01:23 UTC (permalink / raw)
To: Hrishikesh Deshmukh <hdeshmuk@gmail.com>; +Cc: pgsql-sql
On Wed, 29 Mar 2006, Hrishikesh Deshmukh wrote:
> 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!!!
Can you give us the specific schema and query you used? We're only going
to be guessing otherwise.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2006-03-30 01:23 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2006-03-30 01:08 results being col wise rather than row wise Hrishikesh Deshmukh <hdeshmuk@gmail.com>
2006-03-30 01:23 ` Stephan Szabo <sszabo@megazone.bigpanda.com>
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