ernst reeh ([EMAIL PROTECTED]) reports a bug with a severity of 1 The lower the number the more severe it is. Short Description LIKE(~~) OR regular pattern(~) deliver incomplete output Long Description I work with POSTGRES version 6.4, so maybe the bug is already fixed. Please tell me if it's so. A search with LIKE(~~) or with regular patterns (~) won't give you all matching rows. If the first missing letter is a 'y' or a 'z', you won't get this row. (for example: you're searching for 'duftrei%'. You won't find 'duftreiz' or anything starting with 'duftreiz'. The same with 'duftrey'.) I really hope, this bug is already fixed. Bye Ernst Sample Code select * from flexwort; flexseq flex 1 duftreiz 2 duftreize (2 rows) select * from flexwort where flex ~~ 'duftrei%'; (0 rows) select * from flexwort where flex ~ '^duftrei.*'; (0 rows) select * from flexwort where flex ~~ 'duftre%'; flexseq flex 1 duftreiz 2 duftreize (2 rows) No file was uploaded with this report
