Hello,<br /><br />I have <span style="font-weight: bold;">custom </span>postgres code. I get the error below for the
query<br /><br />"select l_orderkey as a from tpcd.orders, tpcd.lineitem where o_orderkey=l_orderkey and
l_partkey<100and l_linestatus='F';"<br /><br />ERROR: stack depth limit exceeded<br />HINT: Increase the
configurationparameter "max_stack_depth".<br /><br />However, the same code runs fine with one condition in where
clause,but fails with the error above in case of multiple conditions.<br /><br />Whats the cause of this error ? I
triedincreasing the stack limit; but it doesnt help.<br /><br />--<br />Suresh Iyengar<br /><p><hr size="1" />Be a
betterfriend, newshound, and know-it-all with Yahoo! Mobile. <a
href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ"> Try it now.</a>