| From: | "Evandro" <evandro(at)horizontenet(dot)com(dot)br> |
|---|---|
| To: | <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Database can´t give the result of the query |
| Date: | 2002-01-22 12:07:03 |
| Message-ID: | 000a01c1a33d$511be640$0d9ed6c8@evandro |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
When I run this:
select c.cod_curriculo, c.mini_curriculo, c.tipo_curriculo, p.nome_pretensao from curriculo c, pretensao_profissional p, curriculo_pretensao cp, curriculo_pagamento cpag where cp.pretensao=p.cod_pretensao_profissional and c.cod_curriculo = cpag.curriculo and cp.curriculo=c.cod_curriculo and (c.mini_curriculo ilike '%gerente%' or p.nome_pretensao ilike '%gerente%') and flag_curriculo_ok='t' and flag_visivel='t' and cpag.data_vencimento >= '2002-01-22' and c.tipo_curriculo=1 Order by p.nome_pretensao limit 10, 0
But if I take out and c.tipo_curriculo=1
select c.cod_curriculo, c.mini_curriculo, c.tipo_curriculo, p.nome_pretensao from curriculo c, pretensao_profissional p, curriculo_pretensao cp, curriculo_pagamento cpag where cp.pretensao=p.cod_pretensao_profissional and c.cod_curriculo = cpag.curriculo and cp.curriculo=c.cod_curriculo and (c.mini_curriculo ilike '%gerente%' or p.nome_pretensao ilike '%gerente%') and flag_curriculo_ok='t' and flag_visivel='t' and cpag.data_vencimento >= '2002-01-22' Order by p.nome_pretensao limit 10, 0
Works fine...
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reinhard Max | 2002-01-22 14:29:30 | 7.2b5 libpq++ include files broken? |
| Previous Message | Hans Plum | 2002-01-21 23:26:51 | Bug: Importing files of different sizes via psql -f |