Skip site navigation (1) Skip section navigation (2)

Database can´t give the result of the query

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 (view raw or flat)
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...


pgsql-bugs by date

Next:From: Reinhard MaxDate: 2002-01-22 14:29:30
Subject: 7.2b5 libpq++ include files broken?
Previous:From: Hans PlumDate: 2002-01-21 23:26:51
Subject: Bug: Importing files of different sizes via psql -f

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group