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
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 |