Re: [GENERAL] 'a' == 'a '

Dann Corbit wrote:
> > -----Original Message-----
> > From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> > Sent: Monday, October 24, 2005 5:57 PM
> > To: Dann Corbit
> > Cc: Tom Lane; Richard_D_Levine(at)raytheon(dot)com; general(at)postgresql(dot)org;
> > pgsql-hackers(at)postgresql(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073