Re: Standard REGEX functions

2022-12-18 Thread Tom Lane
Vik Fearing writes: > I don't suppose project policy would allow us to use an external > library. I assume there is one out there that implements XQuery regular > expressions. Probably, but is it in C and does it have a compatible license? The bigger picture here is that our track record

Re: Standard REGEX functions

2022-12-18 Thread Vik Fearing
On 12/18/22 15:24, Tom Lane wrote: Vik Fearing writes: Are there any objections to me writing a patch to add SQL Standard regular expression functions even though they call for XQuery and we would use our own language? Yes. If we provide spec-defined syntax it should have spec-defined

Re: Standard REGEX functions

2022-12-18 Thread Tom Lane
Vik Fearing writes: > Are there any objections to me writing a patch to add SQL Standard > regular expression functions even though they call for XQuery and we > would use our own language? Yes. If we provide spec-defined syntax it should have spec-defined behavior. I really don't see the

Standard REGEX functions

2022-12-18 Thread Vik Fearing
The standard uses XQuery regular expressions, which I believe are subtly different from ours. Because of that, I had been hesitant to add some standard functions to our library such as . While looking at commit 6424337073589476303b10f6d7cc74f501b8d9d7 from last year (which will come up soon