I need postgresql version of this function
I need postgresql version of this function I am newbie to postgresql and I need a postgresql version of this function - could you help me please? CREATE FUNCTION [dbo].[getpersonname] (@commid INT) RETURNS VARCHAR(255) AS BEGIN DECLARE @personnname varchar(255) SELECT @personnname = COALESCE(@personname + ',', '') + ISNULL(CONVERT(VARCHAR(50), pers.personnname ),'') FROM dbo.comlink comli INNER JOIN dbo.person pers ON personid= comli_personid WHERE comli.comli_commid = @commid RETURN @personnname END What does the function do? – a_horse_with_no_name Jul 1 at 5:11 1 Answer 1 If I understand that code correctly it returns all names separated with c...