strange query plans, won't use index

From: Dustin Sallings <dustin(at)spy(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: strange query plans, won't use index
Date: 1998-11-11 17:35:38
Message-ID: Pine.SGI.3.95.981111093506.16940A-100000@bleu.west.spy.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Does anybody know where there is a difference here:

photo=> explain select cat from wwwacl where userid=getwwwuser('dustin');
NOTICE: QUERY PLAN:

Seq Scan on wwwacl (cost=2.65 size=5 width=4)

EXPLAIN
photo=> explain select cat from wwwacl where userid=6;
NOTICE: QUERY PLAN:

Index Scan using acl_byid on wwwacl (cost=2.24 size=5 width=4)

EXPLAIN

getwwwuser('dustin') returns 6 here.

--
SA, beyond.com My girlfriend asked me which one I like better.
pub 1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin(at)spy(dot)net>
| Key fingerprint = 87 02 57 08 02 D0 DA D6 C8 0F 3E 65 51 98 D8 BE
L_______________________ I hope the answer won't upset her. ____________

Browse pgsql-general by date

  From Date Subject
Next Message Ulf Mehlig 1998-11-12 07:05:19 fmgr.h not found
Previous Message Gene Selkov Jr. 1998-11-11 16:56:16 Re: [INTERFACES] need information about storing methods