String function in monetdb

Question

Does Monetdb supports string function like concat_ws in Postgresql (http://www.postgresql.org/docs/9.1/static/functions-string.html) ?

Edit: Monetdb reference

I look in the Monetdb reference about supported operations, but nothing was related to String functions.

Searching for string aggregate, string_agg, group_concat and so forth doesn't seem to yield anything interesting. So probably not. The better venue to ask this would be the MonetDB devs or a mailing list they maintain. — Denis de Bernardy, Dec 13 '14 at 12:12

score 6 · Accepted Answer · answered Dec 14 '14 at 11:22

I went searching in the MonetDB functions table. The following list shows the set of supported string functions, with aliases omitted and with maximum parameters.

ASCII: SELECT ASCII('a'); → 97
CODE: SELECT CODE(97); → a
CONCAT: SELECT CONCAT('foo', 'bar'); → foobar
INSERT: SELECT INSERT('foXXXar', 2, 3, 'ob'); → foobar
LEFT: SELECT LEFT('foobar', 3); → foo
LENGTH: SELECT LENGTH('foobar'); → 6
LOCATE: SELECT LOCATE('bar', 'foobar', 0); → 4
LOWER: SELECT LOWER('FOOBAR'); → foobar
LIKE: SELECT 'foobar' LIKE 'foo%'; → TRUE
LPAD: SELECT LPAD('foo', 6, '_'); → ___foo
LTRIM: SELECT LTRIM('___foo','_'); → foo
REPEAT: SELECT REPEAT('foo','3'); → foofoofoo
RIGHT: SELECT RIGHT('foobar', 3); → bar
RPAD: SELECT RPAD('foo', 6, '_'); → foo___
RTRIM: SELECT RTRIM('foo___','_'); → foo
SPACE: SELECT SPACE(4); → (4 whitespace characters)
SUBSTRING: SELECT SUBSTRING('foobar', 2, 4); → ooba
TRIM: SELECT TRIM('___foo___','_'); → foo
UPPER: SELECT UPPER('foobar'); → FOOBAR

do you mind telling me how did you find that ? thanks ! – Fopa Léon Constantin Dec 14 '14 at 15:48 — Fopa Léon Constantin, Dec 14 '14 at 15:48
`select * from functions` and continue from there. – Hannes Mühleisen Dec 18 '14 at 14:14 — Hannes Mühleisen, Dec 18 '14 at 14:14

String function in monetdb

1 Answers1