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

CREATE OR REPLACE FUNCTION public.weekof(pg_catalog.timestamptz)
 RETURNS integer
 LANGUAGE sql
 STABLE NOT FENCED SHIPPABLE
AS $function$
    SELECT (EXTRACT(WEEK from $1) )::INTEGER
    $function$
;

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

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