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

[Bruno Dumon (JIRA)]

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

Bruno Dumon commented on DSY-517:
---------------------------------

Could you try if this works on postgresql (through JDBC): {fn right(arg, arg)}

Same for left, concat, the date functions, etc.

These functions are actually standardized (though optional) by the JDBC spec, though they might need to use the above mentioned syntax.

> 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