Thank you for the information.
-----Original Message----- From: martin van dinther [mailto:martin.van.dinther@monetdbsolutions.com] Sent: jeudi 19 novembre 2015 17:45 To: Communication channel for MonetDB users; sebastien.raillard@passman.fr Subject: Re: String functions support in MonetDB
Hi Sébastien,
Are these functions documented somewhere?
There is currently no MonetDB documentation on the built-in SQL scalar functions. It is on our ToDo-list. However most SQL scalar functions conform to standard SQL and behave similar to other RDBMS.
Alternatively you can query following sys tables to find out which functions and arguments exist: select * from sys.functions; select * from sys.args;
See also: https://www.monetdb.org/Documentation/SQLcatalog/Functions%2C%20argument s%2C%20types
Regards, Martin van Dinther
On 29-10-15 10:46, Sébastien RAILLARD (PASSMAN) wrote:
Dear all,
Is there a way to concatenate more than 2 strings at once? The CONCAT function only allow for concatenating 2 strings.
Also, hhe JDBC driver for MonetDB reports that the following string functions are supported (see the list below). Are these functions documented somewhere?
ascii char_length character_length code concat copyfrom difference editdistance editdistance2 get_value_for ilike index insert lcase left length levenshtein like locate lower lpad ltrim next_value_for not_ilike not_like octet_length patindex qgramnormalize repeat replace restart right rpad rtrim similarity soundex space splitpart strings substring trim truncate ucase upper
Best regards, Sebastien
-- Parc d'activité Tolstoï 4 rue Edouard Aynard 69100 Villeurbanne Tél. +33 (0)4 78 95 05 80 Fax +33 (0)4 78 95 00 17 www.passman.fr www.passman-hotels.com www.passman-camping.com www.passman-sante.com https://www.facebook.com/PASSMAN-187787814053/