Re: different sort order in windows and linux version - Mailing list pgsql-general

From Tom Lane
Subject Re: different sort order in windows and linux version
Date
Msg-id 23187.1151902518@sss.pgh.pa.us
Whole thread Raw
In response to Re: different sort order in windows and linux version  (Dragan Matic <mlists@panforma.co.yu>)
Responses Re: different sort order in windows and linux version  (Dragan Matic <mlists@panforma.co.yu>)
Re: different sort order in windows and linux version  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
Dragan Matic <mlists@panforma.co.yu> writes:
> I was about to say the same thing. I think that the whole point in
> having a portable database system is that the data inside the database
> should behave the _same way_ no matter what operating system database is
> running on - client shouldn't be aware of the server OS.

So on that argument, we need to eliminate datatypes float8 and float4
forthwith, because they don't behave quite the same on every machine.
And int8 too, because it's not supported on every machine.  And
--enable-integer-datetimes has got to go; in fact configure should
not have any options at all.

>> Personally, I'd be perfectly happy with pgsql if I could choose to
>> make text operations up to 2-3x slower without the fuss of how it's
>> going to work on a certain platform, in each pgsql version.

Fine for you, not so fine for other people with different concerns.

I'm not unsympathetic to your general point, but black-and-white
arguments won't get far in this discussion.  It's all about tradeoffs
... it's most definitely not about one-size-fits-all.

            regards, tom lane

pgsql-general by date:

Previous
From: "Guy Rouillier"
Date:
Subject: Re: PostgreSQL or mySQL
Next
From: Joost Kraaijeveld
Date:
Subject: Is what I want possible and if so how?