Add CONCAT function for Redshift

Get this error:

No match found for function signature CONCAT(<CHARACTER>, <CHARACTER>, ...)

When using CONCAT, e.g.

SELECT CONCAT('a', city) FROM public.aircraft