| Subject | SORRY Re: [firebird-support] Using external functions in Views |
|---|---|
| Author | Helen Borrie |
| Post date | 2006-05-31T22:28:20Z |
At 08:04 AM 1/06/2006, I wrote:
create view test (
id,
newValue)
as
select id, truncate(fieldname)
from myTable
i.e., the engine deduces the types of the output columns.
Apologies!
./heLen
>Yes, but you have to use the proper syntax!Errm, yes, you do...
>create view test (...is also wrong.
> id BigInt,
> newValue integer)
>as
> select id, truncate(fieldname)
> from myTable
create view test (
id,
newValue)
as
select id, truncate(fieldname)
from myTable
i.e., the engine deduces the types of the output columns.
Apologies!
./heLen