Funkce pro práci s daty v PostgreSQL
Brian Piccolo
Sr. Director, Digital Strategy
TRIM([leading | trailing | both] [characters] from string)
První parametr: [leading | trailing | both]
Druhý parametr: [characters]
Třetí parametr: from string
SELECT TRIM(' padded ');
+--------+ | TRIM | |--------| | padded | +--------+
SELECT LTRIM(' padded ');
+------------+ | LTRIM | |------------| | padded | +------------+
SELECT RTRIM(' padded ');
+----------+ | RTRIM | |----------| | padded | +----------+
SELECT LPAD('padded', 10, '#');
+-------------+ | LPAD | |-------------| | ####padded | +-------------+
SELECT LPAD('padded', 10);
+-------------+ | LPAD | |-------------| | padded | +-------------+
SELECT LPAD('padded', 5);
+------------+ | LPAD | |------------| | padde | +------------+
SELECT RPAD('padded', 10, '#');
+-------------+ | RPAD | |-------------| | padded#### | +-------------+
Preparing Video For Download...
