since ‎07-01-2019
‎01-12-2020
anne-sophiec407
Level 1
Re: Using long text datatype in delivery
Avatar

anne-sophiec407

anne-sophiec407
- Adobe Campaign Standard
Hello DarrenBiz​.Here is the SQL script that we created:DROP FUNCTION IF EXISTS convertToVarchar(parmValue text);CREATE OR REPLACE FUNCTION convertToVarchar(parmValue text)RETURNS VARCHAR AS 'DECLARE v_var_value VARCHAR DEFAULT null;BEGIN v_var_value := parmValue::TEXT; RETURN v_var_value;END;' LANGUAGE plpgsql;Best regards,Anne-Sophie

Views

4.5K

Likes

0

Replies

0