Kevin Macdonald wrote:
> QUERY 2: select sobjid from p1_nrn_road where v = 1
> The plan is "Seq Scan on p1_nrn_road (cost=0.00..22158.54 rows=2 width=8)"
> The plan is wrong: "select min(v) from p1_nrn_road" returns
> 2226497481090365991, which indicates that the query will return 0 rows.
select sobjid from p1_nrn_road where v = '1'
I'm not sure but i think indexes that consists of more than 2 rows have
to be casted to char in PG.
In response to
pgsql-general by date
|Next:||From: Oleg Bartunov||Date: 2004-07-22 09:58:38|
|Subject: Re: [OpenFTS-general] AW: tsearch2, ispell, utf-8 and|
|Previous:||From: Oleg Bartunov||Date: 2004-07-22 09:32:10|
|Subject: Re: Tsearch2 - list of words or phrase with count|