Dann Corbit wrote: > > -----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.
But isn't collating sequence related to ordering? How does this relate to padding? -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend