On Thu, May 20, 2010 at 8:11 AM, Igor Neyman wrote:
>
>
>> -Original Message-
>> From: Scott Marlowe [mailto:scott.marl...@gmail.com]
>> Sent: Wednesday, May 19, 2010 4:15 AM
>> To: A. Kretschmer
>> Cc: pgsql-general@postgresql.org
>> Subject: Re: default ordering of query result - are the
> -Original Message-
> From: Scott Marlowe [mailto:scott.marl...@gmail.com]
> Sent: Wednesday, May 19, 2010 4:15 AM
> To: A. Kretschmer
> Cc: pgsql-general@postgresql.org
> Subject: Re: default ordering of query result - are they
> always guarantee
>
>
On Wed, May 19, 2010 at 1:38 AM, A. Kretschmer
wrote:
> In response to Guillaume Lelarge :
>> > 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 guar
In response to Guillaume Lelarge :
> > 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_colum
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,
>
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 r
