7.3.2 indexes in PL/PgSQL
От | Evgeny Duzhakow |
---|---|
Тема | 7.3.2 indexes in PL/PgSQL |
Дата | |
Msg-id | Pine.LNX.4.20.0304211343380.25047-100000@zeus.philol.msu.ru обсуждение исходный текст |
Ответы |
Re: 7.3.2 indexes in PL/PgSQL
|
Список | 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@philol.msu.ru Moscow State University. Web: http://www.philol.msu.ru
В списке pgsql-bugs по дате отправления: