lib/ultrasphinx/postgresql/concat_ws.sql in ultrasphinx-1.9 vs lib/ultrasphinx/postgresql/concat_ws.sql in ultrasphinx-1.11

- old
+ new

@@ -1,12 +1,12 @@ /* http://osdir.com/ml/db.postgresql.admIN/2003-08/msg00057.html */ -CREATE OR REPLACE FUNCTION MAKE_CONCAT_WS() RETURNS text AS ' +CREATE FUNCTION MAKE_CONCAT_WS() RETURNS text AS ' declare v_args int := 32; - v_first text := ''CREATE OR REPLACE FUNCTION CONCAT_WS(text,text,text) RETURNS text AS ''''SELECT CASE WHEN $1 IS NULL THEN NULL WHEN $3 IS NULL THEN $2 ELSE $2 || $1 || $3 END'''' LANGUAGE sql IMMUTABLE''; - v_part1 text := ''CREATE OR REPLACE FUNCTION CONCAT_WS(text,text''; + v_first text := ''CREATE FUNCTION CONCAT_WS(text,text,text) RETURNS text AS ''''SELECT CASE WHEN $1 IS NULL THEN NULL WHEN $3 IS NULL THEN $2 ELSE $2 || $1 || $3 END'''' LANGUAGE sql IMMUTABLE''; + v_part1 text := ''CREATE FUNCTION CONCAT_WS(text,text''; v_part2 text := '') RETURNS text AS ''''SELECT CONCAT_WS($1,CONCAT_WS($1,$2''; v_part3 text := '')'''' LANGUAGE sql IMMUTABLE''; v_sql text; BEGIN