Public feed #1219374

get_gallery

public sql v1 · immutable
Raw Edit
·published 2008-10-04 23:58 UTC
rendered paste body
CREATE 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