Subject CASE / PIVOT / CROSSTAB
Author donjules2k
Can firebird return a pivot or crosstab table?

Does it support using case or if statements in field names?

such as:

select (case field1
when 'hello' then field2
else field3),
field4,
field5
from mytable


OR


select (if field1 = 'hello' then
field2
else
field3),
field4,
field5
from mytable


Thanks

Giulio