> -----Original Message----- > From: Bruce Momjian [mailto:[EMAIL PROTECTED] > Sent: Monday, October 24, 2005 5:57 PM > To: Dann Corbit > Cc: Tom Lane; [EMAIL PROTECTED]; [EMAIL PROTECTED]; > 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. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
