Re: different sort order in windows and linux version

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Dragan Matic <mlists(at)panforma(dot)co(dot)yu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: different sort order in windows and linux version
Date: 2006-07-03 04:55:18
Message-ID: 23187.1151902518@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Dragan Matic <mlists(at)panforma(dot)co(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ProAce 2006-07-03 08:39:06 High-Availability Question
Previous Message Guy Rouillier 2006-07-03 03:22:47 Re: PostgreSQL or mySQL

Browse pgsql-hackers by date

  From Date Subject
Next Message Andrew Dunstan 2006-07-03 09:59:01 Re: ADD/DROPS INHERIT (actually INHERIT / NO INHERIT)
Previous Message Tom Lane 2006-07-03 03:58:49 Re: odd 7.4 build failure on new sparc machine