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

[Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>]

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