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

Re: Indices y mas indices....

From: "Jaime Casanova" <systemguards(at)gmail(dot)com>
To: "Roberto Guevara" <cygnus2k(at)gmail(dot)com>
Cc: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Re: Indices y mas indices....
Date: 2006-08-24 15:48:41
Message-ID: c2d9e70e0608240848h292c2fd8ye80fd030125eccda@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
On 8/24/06, Roberto Guevara <cygnus2k(at)gmail(dot)com> wrote:
> El EXPLAIN ANALIZE :
> -----------------------------------------------------------------
> Result  (cost=0.00..4.83 rows=1 width=390) (actual time=0.01..0.01
> rows=0 loops=1)
>   ->  Index Scan using detmov_enti on detmov  (cost=0.00..4.83 rows=1
> width=390) (never executed)
>         Index Cond: ((dm_emp = 1::numeric) AND (dm_enti = 71::numeric))
>         Filter: (dm_rnmov IS NULL)
>         Filter: (dm_cta ~~ '90000'::text)
>
> Total runtime: 3.91 msec
> -----------------------------------------------------------------
>
> Me trae el siguiente resultado:
>
> dm_emp  dm_tcom dm_ope  dm_nmov dm_cta  dm_conc dm_sec  dm_cope dm_cfin dm_enti dm_rtcom        dm_rope dm_rnmov
> 1       FC      1       2136    90000   cdf     1       NULL
>
> Que es el esperado.
>

No es el esperado en realidad, me llama la atencion que actual rows
dice 0 pero  te esta regresando un registro... es esto correcto (la
logica me dice que no, pero ya me he equivocado antes ;)?

btw, que version de postgres estas usando? quiza eres victima de
algunos de los bugs que se han corregido en meses anteriores...

-- 
Atentamente,
Jaime Casanova

"Programming today is a race between software engineers striving to
build bigger and better idiot-proof programs and the universe trying
to produce bigger and better idiots.
So far, the universe is winning."
                                       Richard Cook

In response to

Responses

pgsql-es-ayuda by date

Next:From: Alvaro HerreraDate: 2006-08-24 15:49:59
Subject: Re: Indices y mas indices....
Previous:From: Alfredo GarcíaDate: 2006-08-24 15:48:32
Subject: VFP + PostgreSQL

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