SQLize Online / PHPize Online  /  SQLtest Online

A A A
Share      Blog   Popular
Copy Format Clear
/* CREATE FUNCTION concat_lower_or_upper(a text, b text, c numeric, uppercase boolean DEFAULT false) RETURNS text AS $$ SELECT CASE WHEN $4 THEN REPEAT(UPPER($1 || ' ' || $2),$3) ELSE LOWER($1 || ' ' || $2) END; $$ LANGUAGE SQL IMMUTABLE STRICT; SELECT concat_lower_or_upper('tom', 'jerry', TRUE); */ SELECT REPEAT('TOM',3);

Stuck with a problem? Got Error? Ask ChatGPT!

Copy Clear