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
