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');
Maybe use a regular expression?
https://www.postgresql.org/docs/13/functions-matching.html
Ray.
--
Raymond O'Donnell // Galway // Ireland
ray(at)rodonnell(dot)ie