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 по дате отправления:

Предыдущее
От: "matsumura.ryo@fujitsu.com"
Дата:
Сообщение: RE: archive status ".ready" files may be created too early
Следующее
От: Julien Rouhaud
Дата:
Сообщение: Re: doing something about the broken dynloader.h symlink