79YjQPYL

1CREATE TYPE currency AS ENUM('GBP', 'EUR', 'USD');
2	
3CREATE TABLE if not exists transaction(
4  id BIGSERIAL NOT NULL PRIMARY KEY ,
5  amount NUMERIC(35,4) DEFAULT 0.0,
6  transaction_currency currency NOT NULL
7);
8	
9CREATE INDEX transaction_currency ON transaction(transaction_currency);
10	
11INSERT INTO transaction(transaction_currency) VALUES ('EUR'), ('USD'), ('USD');
12	
131. SELECT * FROM transaction WHERE transaction_currency= 'USD'
14	
152. SELECT * FROM transaction WHERE transaction_currency= 'USD'::currency