Re: update substring pattern matching syntax

On 2020-06-28 08:13, Fabien COELHO wrote: v2 patches apply cleanly, compile, global check ok, citext check ok, doc gen ok. No further comments. committed, thanks As I did not find an entry in the CF, so I did nothing about tagging it "ready". Right, I had not registered it yet. -- Peter Ei

Re: update substring pattern matching syntax

Hallo Peter, v2 patches apply cleanly, compile, global check ok, citext check ok, doc gen ok. No further comments. As I did not find an entry in the CF, so I did nothing about tagging it "ready". -- Fabien.

Re: update substring pattern matching syntax

On 2020-06-20 09:08, Fabien COELHO wrote: I cannot say I'm a fan of this kind of keywords added for some arguments. I guess that it allows distinguishing between variants. I do not have the standard at hand: I wanted to check whether these keywords could be reordered, i.e. whether SUBSTRING(text

Re: update substring pattern matching syntax

Hello Peter, 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. Patches apply cleanly, compile

Re: update substring pattern matching syntax

On 6/19/20 11:42 AM, Peter Eisentraut wrote: > At > > it is described that the substring pattern matching syntax in PostgreSQL > does not conform to the current standard.  PostgreSQL implements > >   

Re: update substring pattern matching syntax

pá 19. 6. 2020 v 11:42 odesílatel Peter Eisentraut < peter.eisentr...@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

update substring pattern matching syntax

At 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) wherea