Postgres Pro
Downloads
Home   >   mailing lists

Re: update substring pattern matching syntax - Mailing list pgsql-hackers

From Pavel Stehule
Subject Re: update substring pattern matching syntax
Date
Msg-id CAFj8pRCNt2iO8OyVQF6EzLh-RZ7TE4FOrCjLhMNk9JetPqqrow@mail.gmail.com
Whole thread Raw
In response to update substring pattern matching syntax  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view


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 by date:

Previous
From: "matsumura.ryo@fujitsu.com"
Date:
Subject: RE: archive status ".ready" files may be created too early
Next
From: Julien Rouhaud
Date:
Subject: Re: doing something about the broken dynloader.h symlink