Subject Re: [firebird-support] Using external functions in Views
Author Helen Borrie
At 06:00 AM 1/06/2006, you wrote:
>is it possible to call external functions in a view?
>I'm trying to do something like this:
>create view test as
>select truncate(a.fieldname) from mytable as a
>Is this possible in Firebird?

Yes, but you have to use the proper syntax! Read up on it. You
can't define a view without a column list if the output columns come
from expressions, joins or unions.

create view test (
id BigInt,
newValue integer)
select id, truncate(fieldname)
from myTable