LIKE pattern matching
От | Thomas Lockhart |
---|---|
Тема | LIKE pattern matching |
Дата | |
Msg-id | 398DFBE2.9CC42D45@alumni.caltech.edu обсуждение исходный текст |
Ответы |
Re: LIKE pattern matching
|
Список | pgsql-hackers |
I've updated the LIKE code to make it more SQL9x compliant. I've left in the "permanent backslash" escape character, but I would like to remove it now. Here's why: Usually, we would want to preserve the backward compatibility for a release or so. But in this case, we have to choose backward compatibility or SQL9x compliance. I'd rather move toward compliance and (in this case) a richer feature set. If I leave in the backslash, then you can't use SQL9x syntax to specify a pattern match which has a literal backslash in it. So the "one release grace period" means that we have one more release which does not support the full SQL92 syntax for this feature. If I remove the backslash feature, then instead of matching a literal percent sign ("%") like this: ... 'hi%there' LIKE 'hi\%there' ... you would write ... 'hi%there' LIKE 'hi\%there' ESCAPE '\' ... or of course you could specify another escape character. afaik there is no default explicit escape character in SQL99. Comments? - Thomas
В списке pgsql-hackers по дате отправления: