Hello,

Unfortunately, this is still unsupported. Similar to the post you linked, the postgres methods that we do support are documented https://www.labkey.org/wiki/home/Documentation/page.view?name=labkeySql. We have definitely added to the methods we support since that post was created. If you haven't already you should take a look at that document, there maybe another method you could use.

Thanks,
Chet

Hello,

My apologies, I stated that this was not possible. That is not true, there is a way to create and enable custom database functions. It's not as straightforward as writing a query in the schema browser but involves adding a pass through method in a Java module. Take a look at the link below.

https://github.com/LabKey/platform/blob/aa7e89ca1446b5e797a993bfb6ace04137557a99/api/src/org/labkey/api/query/QueryService.java#L494

Note: This must be done with caution as they become available server-wide, so they need to be safe enough to be allowed in any LabKey SQL query.

Thanks,
Chet