QUOTENAME in JS
Description
Unfortunately, this function is not available in JavaScript, but it can be implemented using predefined functions.
Sample Source Pattern
Implementation Example
function QUOTENAME(string, quote){
return quote.concat(string, quote);
}
Arguments
string
: String expression to delimit.
quote
: Quote to be used as a delimiter.
Return Type
String.
Examples
CREATE OR REPLACE FUNCTION QUOTENAME(str varchar, quote char)
RETURNS string
LANGUAGE JAVASCRIPT
AS
$$
function QUOTENAME(string, quote){
const allowed_quotes = /[\']|[\"]|[(]|[)]|[\[]|[\]]|[\{]|[\}]|[\`]/;
if(!allowed_quotes.test(quote)) throw new TypeError('Invalid Quote');
return quote.concat(string, quote);
}
return QUOTENAME(STR, QUOTE);
$$;
SELECT QUOTENAME('Hola', '`') HELLO;
Last updated