I'm working with a database Firebird 2.5 my question and can generate a query or procedures, for example

my table

CREATE TABLE COUNTRY
(REGION VARCHAR2 (20),
COLOR VARCHAR2 (20))

INSERT VALUES


REGION COLOR
-------------------------------------------------- ----
Malta RED
Malta GRAY
Brazil GREEN ON RED
Brazil WHITE


I would like to have this result


REGION GRAY GREEN ON RED RED WHITE
-------------------------------------------------- -
Brazil 0 1 0 1
Malta 1 0 1 0

I thank you in advance for your help