Order question

From: "Mitch Vincent" <mitch(at)venux(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Order question
Date: 2001-02-13 22:54:08
Message-ID: 000901c0960f$e0497440$0200000a@windows
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hey guys, another strange question here..

If I query and order by a field and there are duplicate values in that
field, what makes one return before the other? Just the first one that PG
comes to on the disk is displayed first or is something else looked at to
determine the order?

Example :

hhs=# SELECT ordernum,fieldname,oid from resultstyle WHERE style_id=1001
order by ordernum asc;
ordernum | fieldname | oid
----------+---------------+---------
1 | J.jobtitle | 1197126
1 | J.inv_id | 1197125
2 | J.updatedon | 1197127
3 | J.empinitials | 1197128

What makes the record with j.jobtitle appear above te other, when ordernum
is the same?

Thanks!

-Mitch

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mitch Vincent 2001-02-13 22:58:35 Re: Order question
Previous Message John Madden 2001-02-13 22:29:54 psql segfault