Hi,
I have a problem with queries on a PostgreSQL database using the JMP query builder...
Indeed some PostgreSQL functions seem not working properly in the query builder...
For example if I want to retrieve part of a string from the position of one of the character:
this command could ben written in PostgreSQL:
SELECT substring('Thomas' from position('h' in 'Thomas') for 2) AS bug_test
But if I write it in "add computed column" in the JMP query builder with the SQL formula editor:
substring('Thomas' from position('h' in 'Thomas') for 2)
I get this error:
whereas this same command is well executed if I write it by hand in SQL Custom:
And in that case it is translated in jsl like other SQL command...
What I don't understand is that I can sometimes write complex formulas in query builder's "computed columns" that are in pure PostgreSQL syntax and everything works fine! Like:
This computed column works fine and return no error message. It is however a specific postgresql code...
Is this a known bug on some PostgreSQL functions? How to work around it?
Thanks for your help!
Franck