How to return table based on if condition in Postgesql

[saswat36]

CREATE Procedure [dbo].[GetMstDropdownd ata]
@FieldType varchar(100)='T ypeid'
AS
BEGIN
if @FieldType='IsO ptionalid'
BEGIN
SELECT 'Yes' as ddlvalue,'Yes' AS ddltext
union
SELECT 'No' as ddlvalue,'No' AS ddltext
END
else if @FieldType='Cat egoryid'
BEGIN
select [CategoryId] as ddlvalue ,[CategoryName] as ddltext
from [CategoryMaster] order by CategoryName
END
END

How to convert above sp in Postgresql