Re: [JBoss-user] Postgres character fields and JBoss-QL

2003-08-27 Thread Matthew Hixson
Thanks, Alex. We have a workaround in place now by comparing against 97, the ASCII value of 'a'. This will work for now, and we'll probably just leave it that way as this query will likely never change. Thanks again, -M@ On Wednesday, August 27, 2003, at 06:36 AM, Alexey Loubyansky wrote

Re: [JBoss-user] Postgres character fields and JBoss-QL

2003-08-27 Thread Alexey Loubyansky
char is a numeric type. 11.2.7.1 Literals An exact numeric literal is a numeric value without a decimal point, such as 57, -957, +62. Exact numeric literals support numbers in the range of Java long. Exact numeric literals use the Java integer literal syntax. alex Matthew Hixson wrote: I have

[JBoss-user] Postgres character fields and JBoss-QL

2003-08-26 Thread Matthew Hixson
I have a JBoss-QL query that contains o.approvalCode = 'a' in the where clause. This is causing JBoss to throw: nested throwable: (org.jboss.ejb.plugins.cmp.ejbql.ParseException: Encountered "\'a\'" at line 1, column 229. Was expecting one of: "ABS" ... "LENGTH" ... "LOCATE" ...