GaussDB(DWS)迁移 – oracle兼容 — dayof

CREATE OR REPLACE FUNCTION public.dayof(pg_catalog.date)
 RETURNS integer
 LANGUAGE sql
 STABLE NOT FENCED SHIPPABLE
AS $function$
    SELECT (EXTRACT(DOW from $1) + 1)::INTEGER
    $function$
;

CREATE OR REPLACE FUNCTION public.dayof(pg_catalog.timestamp)
 RETURNS integer
 LANGUAGE sql
 STABLE NOT FENCED SHIPPABLE
AS $function$
    SELECT (EXTRACT(DOW from $1) + 1)::INTEGER
    $function$
;

CREATE OR REPLACE FUNCTION public.dayof(pg_catalog.timestamptz)
 RETURNS integer
 LANGUAGE sql
 IMMUTABLE NOT FENCED SHIPPABLE
AS $function$
    SELECT (EXTRACT(DOW from $1) + 1)::INTEGER
    $function$
;