Hi everyone,
I'm having a problem where Hibernate inteprets the 'from' as another parameter and just adds the commas to separate them all with the given expression. Is there a way I can force Hibernate to use this literally in a query without dropping down to JDBC?
Code:
substring(shipment.cargoControlNumber.sequence from '[[:digit:]]*') <> ''
Hibernate makes it look like the following:
Code:
substring(shipments1_.sequence, from, '[[:digit:]]*')<>''
Also, if there is another way to achieve the same thing in postgres, I'm all ears. I just want to insure that the sequence contains only digits and not other characters.
Thanks!