Tom Lane wrote:
> Gaetano Mendola <[EMAIL PROTECTED]> writes:
>> CREATE OR REPLACE VIEW v_current_connection AS
>> SELECT ul.id_user
>> FROM user_login ul,
>>current_connection cc
>> WHERE ul.id_user = cc.id_user;
>
>> # explain select * from v_current_connection_test where
>> sp_connec
Gaetano Mendola <[EMAIL PROTECTED]> writes:
> CREATE OR REPLACE VIEW v_current_connection AS
> SELECT ul.id_user
> FROM user_login ul,
>current_connection cc
> WHERE ul.id_user = cc.id_user;
> # explain select * from v_current_connection_test where
> sp_connected_test(id_user) = FALSE;
Hi all,
consider this view:
CREATE OR REPLACE VIEW v_current_connection AS
SELECT ul.id_user
FROM user_login ul,
current_connection cc
WHERE ul.id_user = cc.id_user;
And this is the explain on a usage of that view:
# explain select * from v_current_connection_test where
sp_connected_
