Bugs item #541507, was opened at 2002-04-09 06:30
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=541507&group_id=22866
Category: JBossCMP
Group: v3.0 Rabbit Hole
Status: Open
Resolution: None
Priority: 5
Submitted By: Marco Ladermann (mpl)
>Assigned to: Dain Sundstrom (dsundstrom)
Summary: Wrong PostgreSQL function mapping for locate
Initial Comment:
The function mapping for PostgreSQL of the
string function "locate" is wrong.
locate("lookup", "test", 2)
returns with the definition
(position(?2 in substring(?1 from ?3))+?3)
the value "2"
therefore I suggest that the following
mapping should be used:
(coalesce(nullif(position(?2 in substring(?1
from ?3)), 0) + ?3 -1, 0))
Greetings
Marco
----------------------------------------------------------------------
You can respond by visiting:
http://sourceforge.net/tracker/?func=detail&atid=376685&aid=541507&group_id=22866
_______________________________________________
Jboss-development mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-development
