On Wed, Nov 12, 2003 at 11:38:31 -0300, Franco Bruno Borghesi <[EMAIL PROTECTED]> wrote: > ... WHERE field1 LIKE '%' || field2 || '%'
The first way won't work correctly if field2 has %s in it.
> or
> ... WHERE position(field2 in field1)>0
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
