On Wed, 22 Jun 2005, Pablo Baena wrote: > FOR rec IN SELECT test.id <http://test.id>, test.blow, test1.bla2 > FROM test > LEFT JOIN test1 ON test.id <http://test.id> = test1.id <http://test1.id>WHERE > test1.bla2=\'$1\' LOOP This is going to compare to the exact string '$1' not to the value of the argument since you've quoted it. I think you'd just want test1.bla2 = $1 there. ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your message can get through to the mailing list cleanly
