Nope your right. When I first wrote the function I did not have the + ?3
at the end so it worked fine ...
Marco Ladermann wrote:
> 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
>
>
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-development
