Re: [BUGS] LIKE 'bla%'

2000-09-02 Thread Tom Lane
[EMAIL PROTECTED] writes: > 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' > DELETE FROM MYTABLE WHERE NAME LIKE 'Anto%'; > which gave 'DELETE 1' > Isn't this strange? Yup. What PG ve

[BUGS] LIKE 'bla%'

2000-09-02 Thread pgsql-bugs
Henrik Steffen ([EMAIL PROTECTED]) 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