From: | Bruce Momjian <bruce(at)momjian(dot)us> |
---|---|
To: | Brendan Jurd <direvus(at)gmail(dot)com> |
Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: LIKE, CHAR(), and trailing spaces |
Date: | 2011-02-03 00:48:38 |
Message-ID: | 201102030048.p130mc713230@momjian.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Brendan Jurd wrote:
> On 3 February 2011 10:54, Bruce Momjian <bruce(at)momjian(dot)us> wrote:
> > It seems LIKE is considering the trailing CHAR(10) field spaces as
> > significant, even though our documentations says:
> >
> -- snip --
> >
> > It says trailing spaces are not significant for character comparisons
> > --- the real question is whether LIKE is a comparison. ?Obvioiusly '='
> > is a comparison, but the system does not treat LIKE as a comparison in
> > terms of trailing spaces. ?Is that desired behavior?
>
> Interesting. I would have to say that from the user point of view,
> LIKE is definitely a comparison, and if the rest of the operators on
> bpchar ignore whitespace then LIKE ought to as well.
>
> Is the situation the same for regex matches (~ operators)?
Yes, I think so:
test=> SELECT 'a'::char(10) ~ 'a$';
?column?
----------
f
(1 row)
test=> SELECT 'a'::char(10) ~ 'a *$';
?column?
----------
t
(1 row)
--
Bruce Momjian <bruce(at)momjian(dot)us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ It's impossible for everything to be true. +
From | Date | Subject | |
---|---|---|---|
Next Message | Itagaki Takahiro | 2011-02-03 01:16:21 | Re: log_checkpoints and restartpoint |
Previous Message | Brendan Jurd | 2011-02-03 00:40:51 | Re: LIKE, CHAR(), and trailing spaces |