CODEWITHSUNDEEP
postgresqlmonetdb
Fopa Léon Constantin
Fopa Léon Constantin

Reputation: 12373

String function in monetdb

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.

Upvotes: 2

Views: 1081

Answers (1)

Hannes Mühleisen
Hannes Mühleisen

Reputation: 2562

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

Upvotes: 6

Related Questions