Hi! Could we please enable some services and cookies to improve your experience and our website?

SQLize | PHPize | SQLtest

Online Sandbox for SQL and PHP: Write, Run, Test, and Share SQL Queries and PHP Code

A A A
Login    Share code      Blog   FAQ
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 AI support!

Copy Clear