Skip site navigation (1) Skip section navigation (2)

LIKE 'bla%'

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: LIKE 'bla%'
Date: 2000-09-02 09:18:18
Message-ID: 200009020918.e829IIh55600@hub.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Henrik Steffen (steffen(at)city-map(dot)de) reports a bug with a severity of 2
The lower the number the more severe it is.

Short Description
LIKE 'bla%'

Long Description
I just wanted to delete a record from a table, using

DELETE FROM MYTABLE WHERE NAME LIKE 'Ant%';

knowing that there existed only one record with 'Anton' as name.
However, the code above delivered 'DELETE 0'

Then I did this:
DELETE FROM MYTABLE WHERE NAME LIKE 'Anto%';
which gave 'DELETE 1'

Isn't this strange?


Sample Code
DELETE FROM MYTABLE WHERE NAME LIKE 'Ant%';
<=>
DELETE FROM MYTABLE WHERE NAME LIKE 'Anto%';


No file was uploaded with this report


Responses

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2000-09-02 16:08:55
Subject: PG still fussy to compile on Solaris + GCC, may still need Sun ld
Previous:From: Richard EllisDate: 2000-09-02 06:04:33
Subject: Possible bug in referential integrity system

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group