default ordering of query result - are they always guarantee

From: Yan Cheng CHEOK <yccheok(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: default ordering of query result - are they always guarantee
Date: 2010-05-19 03:06:56
Message-ID: 731331.59045.qm@web65701.mail.ac4.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I have the following table :

CREATE TABLE measurement_1
(
measurement_id serial NOT NULL,
fk_unit_id int NOT NULL,
"value" double precision,
measurement_type text NOT NULL,
measurement_unit text NOT NULL
);

When I want to retrieve the query. By default, the query result are ordered in ascending order, by using measurement_id.

SELECT measurement_type, value, measurement_unit
FROM
measurement_1

This is the default behavior I want. However, I am not sure whether this is always guarantee? Or shall I explicitly make the query in the following form? Will this have performance impact on row with millions?

SELECT measurement_type, value, measurement_unit
FROM
measurement_1 ORDER BY measurement_id ASC

Thanks.

by ensuring measurement_1 result are ordered in ascending
Thanks and Regards
Yan Cheng CHEOK

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Guillaume Lelarge 2010-05-19 04:42:14 Re: default ordering of query result - are they always guarantee
Previous Message Joshua Tolley 2010-05-19 02:34:26 Re: Connection lost