[Phpgroupware-users] Postgresql CONCAT function

[A.R.Davies]

Hello

I'm not sure this is the correct place to post this but here goes.

I am running phpGroupWare on SuSE 7.3 and Postgresql, in the phonelog,
index.php the CONCAT function does not work, pgsql uses '||' to join 
strings.

$db1->query("SELECT pl_id, pl_callfrom_id, pl_callfrom_txt, 
account_firstname ||
 ' ' || account_lastname, pl_calldate, pl_status, pl_desc_short FROM 
phonelog_en
try, phpgw_accounts where pl_callfor=account_id $query_filters 
$query_order");

was :-

$db1->query("SELECT pl_id, pl_callfrom_id, pl_callfrom_txt, 
CONCAT(account_first
name, ' ', account_lastname), pl_calldate, pl_status, pl_desc_short FROM 
phonelo
g_entry, phpgw_accounts where pl_callfor=account_id $query_filters 
$query_order"
);

Regards


Roger