From: | pgsql-bugs(at)postgresql(dot)org |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | The ignored "_" character |
Date: | 2001-05-07 07:01:28 |
Message-ID: | 200105070701.f4771Sq02893@hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
Laszlo Kohl (lkohl(at)matavnet(dot)hu) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
The ignored "_" character
Long Description
Hi,
I am Laszlo from Hungary.
I have some problem with PostgreSQL.
Environment:
PostgreSQL version: 7.0.3
Server OS: RedHat 5.2 , Linux-Mandrake 7.2
Client OS: RedHat 5.2 , Windows NT (pgAdmin) , Linux-Mandrake 7.2
The problem:
I create some users in database and then want to list them.
The "_" character is ignored in query statement.
The query: "select usename from pg_user where usename Like '%_u%' ;"
produces the same result as the query:
"select usename from pg_user where usename Like '%u%' ;"
Sample Code
/* Create users... */
create user i_adminuser with sysid 40 password 'adminuser' createdb createuser ;
create user i_login with sysid 41 PASSWORD 'login';
create user i_lekerdezo1 with sysid 45 password 'lekerdezo1';
create user i_ugyintezo1 with sysid 46 password 'ugyintezo1' createuser ;
/* The query 1: */
select usename from pg_user where usename Like '%_u%' ;
/* The Result: */
usename
--------------
i_adminuser
i_ugyintezo1
(2 rows)
/* The query 2: */
select usename from pg_user where usename Like '%u%' ;
/* The Result: */
usename
--------------
i_adminuser
i_ugyintezo1
(2 rows)
No file was uploaded with this report
From | Date | Subject | |
---|---|---|---|
Next Message | Karel Zak | 2001-05-07 08:12:53 | Re: The ignored "_" character |
Previous Message | Tom Lane | 2001-05-06 16:09:41 | Re: Big problems with query optimization |