mysqlsqlingres4gl

SIMILAR TO predicate ingres 4gl issue

I used this query to get a regular expression with successful results. 

select * from paso_string where 'AAAAAAAAA' SIMILAR TO columname

But, When I use this query into ingres 4GL show me an error when I try to compiling and show me the follow issue.

E_OS0100 Syntax error on line The last symbol read was 'similar'

Solution

  • 4GL has its own parser, which sadly is often behind the SQL parser when it comes to new features.

    The standard work-around is to put your SQL statement into a string and then do execute immediate :string;