Re: default ordering of query result - are they always guarantee

Le 19/05/2010 05:06, Yan Cheng CHEOK a écrit :
> 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?

An you're right. It's not guaranted. The only guaranted way is to use
ORDER BY your_column.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com