| Subject | AW: [firebird-support] more then two unions |
|---|---|
| Author | Klement Guenther - Munich-MR |
| Post date | 2003-07-25T14:15:19Z |
Thomas wrote
This was also my first thought. But CASTs only work within WHERE clauses. Don't they?
SQL can sometimes be very tricky.
Guenther
PS: Thanks to Daniel who find out the problem.
> Explictely cast the first column with e.g. a VARCHAR(5)do not work.
> select cast('ident' as varchar(5)), count(*) from identtab
> union...
This was also my first thought. But CASTs only work within WHERE clauses. Don't they?
SQL can sometimes be very tricky.
Guenther
PS: Thanks to Daniel who find out the problem.