From: | Evgeny Duzhakow <diabolo(at)philol(dot)msu(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | 7.3.2 indexes in PL/PgSQL |
Date: | 2003-04-21 09:49:06 |
Message-ID: | Pine.LNX.4.20.0304211343380.25047-100000@zeus.philol.msu.ru |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
I have select like that:
SELECT playerid FROM players WHERE nickname = 'qq' AND password = 'qqq';
query plan:
auction=# explain SELECT playerid FROM players WHERE nickname = 'qq' AND
password = 'qqq';
QUERY PLAN
--------------------------------------------------------------------------------------------------
Index Scan using nick_pass on players (cost=0.00..6.01 rows=1 width=4)
Index Cond: ((nickname = 'qq'::character varying) AND ("password" = 'qqq'::character varying))
(2 rows)
but in procedure on PL/PgSQL this select realy do sequense scan:
--- cut from create_session procedure ---
SELECT playerid INTO _playerid FROM players WHERE nickname = _nickname AND password = _passwd;
--- cut ---
Where i'm wrong? or that realy bug?
always thanks.
Diabolo.
--- ---
System Administrator of Phone: +7-095-939-1478
the Philological Faculty of E-Mail: diabolo(at)philol(dot)msu(dot)ru
Moscow State University. Web: http://www.philol.msu.ru
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-bugs | 2003-04-21 14:18:31 | Bug #951: Creating table fails if inherited table has no columns. |
Previous Message | bmp | 2003-04-21 08:06:58 | Primary key violation |