Thanks, will commit change as soon as sourcefouge cvs is back on line.
-dain
----- Original Message -----
From: "Marco Ladermann" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, August 21, 2001 3:33 AM
Subject: Re: [JBoss-dev] SQL function mapping
> 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
