At 02:14 PM 5/24/2002 +0300, Riho-Rene Ellermaa wrote:

>In original script there was:
>
> CREATE VIEW USERS (USER_NAME) AS
> SELECT *
> FROM users2
> WHERE EXISTS (SELECT * FROM log_proc(users2.user_name));
>
>Interbase accepted it, but Firebird complained about number of columns not
>matching.

Firebird is fussier about name matches than InterBase. That's
a nuisance for people like you, who have something that works.
It's not exactly what you asked for, that doesn't matter because
it's what you want. The fussiness is good for people who
get very peculiar results when they offer a not-quite-right
query. Protection for the naive ...



Regards,

Ann
www.ibphoenix.com
We have answers.