Re: update substring pattern matching syntax
| От | Pavel Stehule |
|---|---|
| Тема | Re: update substring pattern matching syntax |
| Дата | |
| Msg-id | CAFj8pRCNt2iO8OyVQF6EzLh-RZ7TE4FOrCjLhMNk9JetPqqrow@mail.gmail.com обсуждение исходный текст |
| Ответ на | update substring pattern matching syntax (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>) |
| Список | pgsql-hackers |
pá 19. 6. 2020 v 11:42 odesílatel Peter Eisentraut <peter.eisentraut@2ndquadrant.com> napsal:
At
<https://wiki.postgresql.org/wiki/PostgreSQL_vs_SQL_Standard#Obsolete_syntax_for_substring.28.29>
it is described that the substring pattern matching syntax in PostgreSQL
does not conform to the current standard. PostgreSQL implements
SUBSTRING(text FROM pattern FOR escapechar)
whereas the current standard says
SUBSTRING(text SIMILAR pattern ESCAPE escapechar)
The former was in SQL99, but the latter has been there since SQL:2003.
It's pretty easy to implement the second form also, so here is a patch
that does that.
+1
Pavel
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
В списке pgsql-hackers по дате отправления: