Re: [HACKERS] textlike under the LIKE operator for char(n)

2016-05-06 Thread Kohei KaiGai
2016-05-06 23:17 GMT+09:00 Kevin Grittner : > On Fri, May 6, 2016 at 8:58 AM, Kohei KaiGai wrote: > >> postgres=# select 'abcd'::char(20) LIKE 'ab%cd'; >> ?column? >> -- >> f >> (1 row) >> >> postgres=# select 'abcd'::char(4) LIKE 'ab%cd'; >> ?column? >> -- >> t >> (1 row) >> >

Re: [HACKERS] textlike under the LIKE operator for char(n)

2016-05-06 Thread Kevin Grittner
On Fri, May 6, 2016 at 8:58 AM, Kohei KaiGai wrote: > postgres=# select 'abcd'::char(20) LIKE 'ab%cd'; > ?column? > -- > f > (1 row) > > postgres=# select 'abcd'::char(4) LIKE 'ab%cd'; > ?column? > -- > t > (1 row) > > LIKE operator (that is eventually processed by textlike) c

[HACKERS] textlike under the LIKE operator for char(n)

2016-05-06 Thread Kohei KaiGai
Hi, I found a mysterious behavior when we use LIKE operator on char(n) data type. postgres=# select 'abcd'::char(20) LIKE 'ab%cd'; ?column? -- f (1 row) postgres=# select 'abcd'::char(4) LIKE 'ab%cd'; ?column? -- t (1 row) LIKE operator (that is eventually processed by text