SQL string comparison with postgresql regex functions

LabKey Support Forum (Inactive)
SQL string comparison with postgresql regex functions Jon (LabKey DevOps)  2017-08-28 14:07
Status: Closed
 
Hi Myriam,

I don't think this is something we support, but I'd like to know more details as to what you're specifically looking to do here.

When you say you want to use a tilde for a string comparison, what were you hoping to do a comparison against?

Can you write us an example of how you're hoping the data will appear based on what you'd like it to do?

The regex_replace function is usable in LabKey SQL, but it is very specific in its job to replace values rather than trying to do comparisons alone.

Regards,

Jon