Re: SELECT in VCHAR column for strings with TAB - Mailing list pgsql-general

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@rodonnell.ie