On 8/10/20 9:37 AM, pgml@xxxxxx wrote:
Hello,
my SQL question is, why psql doesn't return the record?
create table lll (text char(100));
insert into lll (text) values ('10% - Ersthelfer');
select * from lll where text like '10% - Ersthelfer';
Other databases (Maria, SQL Server, YARD) do this.
What can I do in pg, to get the result?
A little documentation goes a long way:) :
https://www.postgresql.org/docs/12/functions-matching.html#FUNCTIONS-LIKE
Thank you and best regards, Martin
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
