Re: SELECT in VCHAR column for strings with TAB

2021-06-10 Thread Tom Lane
Matthias Apitz writes: > I want to search in a VCHAR column for a string with two TAB at the end. > I tried some things w/o any luck, like: > select * from acq_vardata where name=concat('Test202112', 9, 9); > select * from acq_vardata where name=concat('Test202112', '\t\t'); By default, backslas

Re: SELECT in VCHAR column for strings with TAB

2021-06-10 Thread Ray O'Donnell
On 10/06/2021 14:30, Matthias Apitz wrote: Hello, I want to search in a VCHAR column for a string with two TAB at the end. I tried some things w/o any luck, like: select * from acq_vardata where name=concat('Test202112', 9, 9); select * from acq_vardata where name=concat('Test202112', '\t\t');