Emi Lu writes:
> With ibatis, do overlap checking:
> (1) select (DATE #begin_date#, DATE #end_date#) overlaps
> (DATE '2008-01-01', DATE '2009-01-01')
> . #begin_date# is varchar
> . #end_date# is varchar
> Cause: java.sql.SQLException: ERROR: syntax error at or near "$4"
> However, when I up
Good morning,
With ibatis, do overlap checking:
(1) select (DATE #begin_date#, DATE #end_date#) overlaps
(DATE '2008-01-01', DATE '2009-01-01')
. #begin_date# is varchar
. #end_date# is varchar
Always get:
Cause: java.sql.SQLException: ERROR: syntax error at or near "$4"
Howeve