Re: default ordering of query result - are they always guarantee - Mailing list pgsql-general

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