Question about like - Mailing list pgsql-general

From Cornelia Boenigk
Subject Question about like
Date
Msg-id 004f01c18cdc$47eb9600$aec1fea9@zwerg98
Whole thread Raw
In response to Database recovery  (tony <tony@animaproductions.com>)
List pgsql-general
Merry Christmas and hello everybody

I have a test table with a field called 'name' which have three
entries:
Johanna
Karl
Uwe

If I query this table with
- select name from test where name like 'Uwe';
- select name from test where name like 'U_e';
- select name from test where name like '%e';
or
- select name from test where name like '---';

in all cases pg responds with 0 rows found.

I was expecting another result;-(
Does anybody have a hint or an explanation for this behaviour?
My system is RedHat 7.1 with PostgreSQL 7.1.3

Many thanks
Conni



pgsql-general by date:

Previous
From: "Serguei Mokhov"
Date:
Subject: [OT] Merry Xmas!
Next
From: Joe Conway
Date:
Subject: Re: Question about like