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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
