| 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: | Whole Thread | Raw Message | 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 |