Обсуждение: Who can resolve this BUG ?

INM1=# explain select ref_num from grls where ag_id in (24);
Index Scan using grls_ag_id on grls  (cost=0.00..597.87 rows=849 width=12)

IMN1=# explain select ref_num from grls where ag_id in (select 24);
Seq Scan on grls  (cost=0.00..992.44 rows=30195 width=12)
  SubPlan
    ->  Materialize  (cost=0.00..0.00 rows=0 width=0)
          ->  Result  (cost=0.00..0.00 rows=0 width=0)

IMN1=# explain select ref_num from grls where ag_id = (select 24);
Index Scan using grls_ag_id on grls  (cost=0.00..597.87 rows=849 width=12)
  InitPlan
    ->  Result  (cost=0.00..0.00 rows=0 width=0)

". . . in (24)  " work in 35 faster than ". . . in (select 24)". In the
last don't use indices for increase perfomans.
It's  been normaly work in PostgreSQL version 7.2 ? Or not?

P.S.
Sorry my English.

Dear All,

 I am trying to configure the access to the postgreSQL server through web. I
would like that someone could give
a general idea of how the password politic works in PostgreSQL.

 Let me explain what I have tried so far.

 I want to do access to PostgreSQL using password encryption. What I have
read is that in that case you need to use
the passwd file.

 I tried to use the commands for adding a user to the system (create user or
createuser on the system prompt) but I have
seen that in that case, postgreSQL dont add a entry for the new user in the
passwd file. BUT if I use the command "pg_passwd passwd" and gives the
details for the new user, then it does add the entry to the passwd file, but
not in the pg_pwd file where stores the names of the users of postgreSQL (I
tried to access through the psql command to the database and the user doesnt
exist after only have added using pg_passwd).

 Does this mean that I have to do this two steps?. I am developing an
administration application under C++ Builder and I would like to add users
from that application using SQL, trigger, fuctions or whatever. How can I do
it without doing it manually?

 I hope I have explained myseft clearly.

 Thank you in advance and sorry for my English

 Miguel