[SQL] Similar tables, different indexes performance

2004-12-13 Thread Alvaro Nunes Melo
'structures and record counts. I think this is the place where I can most probably get help about performance issues. Thanks in advance, -- +-------+ | Alvaro Nunes MeloAtua Sistemas de Informacao | | [EMAIL PROTECTED]www.atua.com

[SQL] Set Returning Function problem

2004-12-06 Thread Alvaro Nunes Melo
gt; test=> SELECT cod, (srf_foo(50)).bar test-> FROM foo; cod | bar -----+- (0 records) Thanks in advance, -- +---+ | Alvaro Nunes MeloAtua Sistemas de Informacao | | [EMAIL PROTECTED]www.atua.com.br | |UIN - 42722678(54) 3

[SQL] Difficulties to use a Set Returning Function on a join

2004-09-13 Thread Alvaro Nunes Melo
t SELECT osp.* FROM pedido p JOIN obtem_situacao_pedido(pedido.cd_pedido) osp USING(cd_pedido); NOTICE: Adding missing FROM-clause entry for table "pedido" ERROR: FROM function expression may not refer to other relations of same query level Thanks in advance, -- +-------