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

[Andreas Deininger (JIRA)]

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

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

Closely related to that, the implementation of the LEFT() function of daisy's query language depends on the existence of the SQL string function LEFT() which is not available on other databases (e.g. PostgreSQL).

> 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, Repository - querying and indexing
>     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