files, maybe I find there something.
If I found something "strange" I post it.
Thankx to all.
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Andrei Bintintan" <[EMAIL PROTECTED]>
Cc: "[ADMIN]" <[EMAIL PROTECTED]>
here.
I have another machine on which the result is
okayI don't have a clue.
Andy.
- Original Message -
From:
Donald Fraser
To: [ADMIN]
Sent: Tuesday, November 25, 2003 6:21
PM
Subject: Re: [ADMIN] Sensitive sort
problem?
PostgreSQL 7.3.x and
files, maybe I find there something.
If I found something "strange" I post it.
Thankx to all.
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Andrei Bintintan" <[EMAIL PROTECTED]>
Cc: "[ADMIN]" <[EMAIL PROTECTED]>
On Tue, 25 Nov 2003, Andrei Bintintan wrote:
> I give an example:
>
> These are the datas from the table names:
>
> id n1 n2
> 1 AaAaAaAa
> 2X X
> 3A A
> 4 aa
> 5 abab
> 6 _Y_Y
> 8 ..a..a
> 9 .x.x
> 7 ...a...a
>
> If I run: select * fro
- Original Message -
> "Donald Fraser" <[EMAIL PROTECTED]> writes:
> > PostgreSQL 7.3.x and anything below has never had case insensitive sorting
=
> > - period.
>
> This is incorrect. In point of fact it will depend on the locale the
> database is running under. I think the OP's problem
here.
I have another machine on which the result is
okayI don't have a clue.
Andy.
- Original Message -
From:
Donald Fraser
To: [ADMIN]
Sent: Tuesday, November 25, 2003 6:21
PM
Subject: Re: [ADMIN] Sensitive sort
problem?
PostgreSQL 7.3.x and any
"Donald Fraser" <[EMAIL PROTECTED]> writes:
> PostgreSQL 7.3.x and anything below has never had case insensitive sorting =
> - period.
This is incorrect. In point of fact it will depend on the locale the
database is running under. I think the OP's problem is he re-initdb'd
without noting what lo
PostgreSQL 7.3.x and anything below has never had
case insensitive sorting - period.
I can't speak for the new 7.4 version?
If you want to add a case insensitive data type try
this:
http://gborg.postgresql.org/project/citext/projdisplay.php
Regards
Donald Fraser.
- Original Messag