SQL Question about like - Mailing list pgsql-general

From pgml@gmx.de
Subject SQL Question about like
Date
Msg-id 00d20cc2-0c97-8ce7-768a-a2c8bc396d19@gmx.de
Whole thread Raw
Responses Re: SQL Question about like  (Ron <ronljohnsonjr@gmail.com>)
Re: SQL Question about like  (Adrian Klaver <adrian.klaver@aklaver.com>)
Re: SQL Question about like  (Michael Nolan <htfoot@gmail.com>)
List pgsql-general
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?

Thank you and best regards, Martin




pgsql-general by date:

Previous
From: Ashkar Dev
Date:
Subject: UUID or auto-increment
Next
From: Ravi Krishna
Date:
Subject: Re: UUID or auto-increment