PostgreSQL Hacks - Re: [GENERAL] 'a' == 'a '

Author

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

Dann Corbit

2005-10-27, 8:13 am

> -----Original Message-----
> From: Bruce Momjian & #91;mailto:pgman@can
dle.pha.pa.us]
> Sent: Monday, October 24, 2005 5:57 PM
> To: Dann Corbit
> Cc: Tom Lane; Richard_D_Levine@ray
theon.com; general@postgresql.org;
> pgsql-hackers@postgresql.org
> Subject: Re: [GENERAL] [HACKERS] 'a' == 'a '
>
> Dann Corbit wrote:
>
> 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

Bruce Momjian

2005-10-27, 8:13 am

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

Sponsored Links