get_gallery
public sql v1 · immutableCREATE FUNCTION get_gallery(GalleryId INTEGER) RETURN SETOF "Galleries" AS$$BEGIN IF GalleryId = 0 THEN SELECT * FROM Galleries WHERE isDefault=true; ELSE SELECT * FROM Galleries WHERE Id=$1; END IF;END;$$ LANGUAGE=plpgsql