Re: [GENERAL] 'a' == 'a ' - Mailing list pgsql-hackers

From Dann Corbit
Subject Re: [GENERAL] 'a' == 'a '
Date
Msg-id D425483C2C5C9F49B5B7A41F8944154757D233@postal.corporate.connx.com
Whole thread Raw
Responses Re: [GENERAL] 'a' == 'a '
List pgsql-hackers
> -----Original Message-----
> From: Bruce Momjian [mailto:pgman@candle.pha.pa.us]
> Sent: Monday, October 24, 2005 5:57 PM
> To: Dann Corbit
> Cc: Tom Lane; Richard_D_Levine@raytheon.com; general@postgresql.org;
> pgsql-hackers@postgresql.org
> Subject: Re: [GENERAL] [HACKERS] 'a' == 'a '
>
> Dann Corbit wrote:
> > Document the collating sequences used for the character types.
>
> Sorry, I don't understand that.  What does it mean?

According to the standard, comparisons against character types are
supposed to PAD with either <space> or <PAD CHAR> according to the
collating sequence and not according to the data type.

Since the padding behavior of PosgreSQL comparisons for character types
is different according to the data type and not the collating sequence,
what is needed is simply to define the collating sequence used for
different character types.



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: sort_mem statistics ...
Next
From: Tom Lane
Date:
Subject: Re: New timezone data