On Monday, 20. August 2001 19:20, Dain Sundstrom wrote:
> Thanks, checked it in.
>
> -dain
>
<snip>
> > It is simply two functions
> >
> > position(?2 in substring(?1 from ?3))+?3
> >
Sorry for complaining so late, but it is not as simple as this.
position( 'findme' , 'wheretolookfor', 3) should be 0 and not 3 or am I
wrong?
Therefore use this for PostgreSQL:
coalesce( nullif( position( ?1 in substring( ?1 from ?3 ) ), ?3 ) + ?3, 0 )
Marco
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
