Dann Corbit wrote:
> > -----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.
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,
Pennsylvania19073