Breaking News: Grepper is joining You.com. Read the official announcement!

Using CASE within a stored procedure Postgres

Obedient Osprey answered on November 29, 2022 Popularity 1/10 Helpfulness 1/10

answer Using CASE within a stored procedure Postgres

Using CASE within a stored procedure Postgres

Comment

CREATE OR REPLACE FUNCTION ReturnWeekName(weekno double precision)
RETURNS  varchar AS $$

DECLARE 
     weekname varchar;
BEGIN

    weekname := CASE 
        WHEN weekno = 0 THEN 'Sunday'
        WHEN weekno = 1 THEN 'Monday'
        WHEN weekno = 2 THEN 'Tuesday'
        WHEN weekno = 3 THEN 'Wednesday'
        WHEN weekno = 4 THEN 'Thursday'
        WHEN weekno = 5 THEN 'Friday'
        WHEN weekno = 6 THEN 'Saturday'
    END;
    return weekname;
END;
$$
LANGUAGE plpgsql;

Popularity 1/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: case procedure sql using

Link to this answer
Share Copy Link