LIKE - bug or expected behaviour?

Hello,

we have user specific views with names that follow this pattern:

_table_username

Strangely the following select:

SELECT table_name FROM information_schema.views WHERE table_schema = current_schema() AND table_name LIKE
'\_%\_username';

does also match views with names like table_username.

This syntax does match as expected though:

SELECT table_name FROM information_schema.views WHERE table_schema = current_schema() AND table_name LIKE
E'\\_%\\_username';

Is this behaviour to be expected?

Thank you very much,

Peter


--
GRATIS für alle GMX-Mitglieder: Die maxdome Movie-FLAT!
Jetzt freischalten unter http://portal.gmx.net/de/go/maxdome01