Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[F] Concat not defined in PostgreSQL [C-Michael83]
#1
It occurs in many places, for example when sending mass mail to users.

MyBB tries to use CONCAT in SQL queries, but it is not defined in PostgreSQL. My suggestion is to define it while installing/upgrading with:

CREATE FUNCTION CONCAT(text,text)
RETURNS text
LANGUAGE SQL
AS $$ SELECT 'a'||'b' $$;

CREATE FUNCTION CONCAT(text,text,text)
RETURNS text
LANGUAGE SQL
AS $$ SELECT 'a'||'b'||'c' $$;
MyBB 1.4.4
PHP: 5.2.6-pl7-gentoo
PostgreSQL 8.2.7


Messages In This Thread
[F] Concat not defined in PostgreSQL [C-Michael83] - by Peter de Sowaro - 12-07-2008, 06:59 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)