SELECT 'be_r' LIKE 'b_e__r' ESCAPE '_' AS "true";
returns false, because it doesn't ignore the invalid '_e' (compare to '\e')
escape.
test in pg_regress/strings_like
Fabian
SQL/Core
SQL "stable"
Public
|
Date: 2009-08-02 09:25 fixed in Stable, will first appear in next feature release |
| Field | Old Value | Date | By |
|---|---|---|---|
| status_id | Open | 2009-08-02 09:25 | mr-meltdown |
| resolution_id | None | 2009-08-02 09:25 | mr-meltdown |
| close_date | - | 2009-08-02 09:25 | mr-meltdown |
Copyright © 2010 Geeknet, Inc. All rights reserved. Terms of Use