Question about like

From: "Cornelia Boenigk" <poppcorn(at)cornelia-boenigk(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Question about like
Date: 2001-12-25 00:34:51
Message-ID: 004f01c18cdc$47eb9600$aec1fea9@zwerg98
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joe Conway 2001-12-25 02:06:32 Re: Question about like
Previous Message Serguei Mokhov 2001-12-24 23:52:29 [OT] Merry Xmas!