Funny results in query

From: Chris Pizzo <chris(at)artinside(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Funny results in query
Date: 2003-01-30 20:39:32
Message-ID: 5.2.0.9.1.20030130152341.00a7cc68@216.162.64.162
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Hi all,
can someone explain why this is happening?

select field1, field2, field3, field4, field5, field6, field7, field8,
field9, field10, field11, field12, field13, field14 from table where
field18 = 't' order by us_retail_price asc offset 48 limit 6;

returns...
field1
------------+
H1205
B1494
B1496
H1204
B1495
B1497

but ...

select field1, field2, field3, field4, field5, field6, field7, field8,
field9, field10 from table where field18 = 't' order by us_retail_price
asc offset 48 limit 6;

returns...
field1
------------+
H1180
H1179
H1205
B1496
H1204
B1497

it appears the number of fields i have in the select is affecting the
results. I don't understand why?

running 7.2.1

Thanks in advance,
Chris

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andres Ledesma 2003-01-30 21:03:19 where is libpq.so
Previous Message guillermo schulman 2003-01-30 18:32:21 Replication/Clustering Solution