[Info-ingres] Am I doing SIMILAR wrong?

[Martin Bowes]

That certainly looks neater than this: select * from foo where name similar to '[-[:UPPER:][:punct:]^!#$&<=@/:;`~,"'']+'

And I think you should ask Actian for a clarification on this one.

Marty

-----Original Message-----
From: Roy Hann [mailto:specially at processed.almost.meat] 
Sent: 23 July 2019 13:29
To: info-ingres at lists.planetingres.org
Subject: Re: [Info-ingres] Am I doing SIMILAR wrong?

Martin Bowes wrote:

> It's something going wrong with the period...or our interpretation of it...!

So it's not just me then. I don't know whether to be pleased or not.

For now I've worked around it by deleting the periods first:

  select * from foo where replace(name,'.','') 
        not similar to '[-''ABCDEFGHIJKLMNOPQRSTUVWXYZ]+'

Roy

PS, I'm not using [:UPPER:] or [A-Z] because my real character class
contains additional accented characters. Just listing them all seems
aesthetically smoother.  :-)


_______________________________________________
Info-ingres mailing list
Info-ingres at lists.planetingres.org
https://lists.planetingres.org/mailman/listinfo/info-ingres