[daisy] [JIRA] Commented: (DSY-517) database indepent implementation of RIGHT() function

Thu Aug 2 08:28:50 CDT 2007

    [ http://issues.cocoondev.org//browse/DSY-517?page=comments#action_13300 ] 

Andreas Deininger commented on DSY-517:
---------------------------------------

Yes, these jdbc escaped functions work on PostgreSQL with the JBC driver 8.x

> database indepent implementation of RIGHT() function
> ----------------------------------------------------
>
>          Key: DSY-517
>          URL: http://issues.cocoondev.org//browse/DSY-517
>      Project: Daisy
>         Type: Bug
>   Components: Repository - database support
>     Versions: 2.1
>  Environment: SVN trunk
>     Reporter: Andreas Deininger
>     Priority: Minor

>
> Currently, the implementation of the RIGHT() function of daisy's query language depends on the existence of the SQL string function RIGHT(). This function, however, is not available on other databases (e.g. PostgreSQL). Therefore, the Implementation of taht function should be based on the SQL SUBSTRING() funtion (at least for those databases, where the SQL string function RIGHT() does not exist).
> Affected files: org/outerj/daisy/query/model/functions/RightFunction.java, org/outerj/daisy/jdbcutil/JdbcHelper.java

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.cocoondev.org//secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira