- snippet.sql
-- Function: public.next_val(text) -- DROP FUNCTION public.next_val(text); CREATE OR REPLACE FUNCTION public.next_val(text) RETURNS text AS $BODY$ SELECT to_char(now(), 'YYYYMMDD') || to_char(NEXTVAL($1), 'fm000000') $BODY$ LANGUAGE SQL VOLATILE COST 100; ALTER FUNCTION public.next_val(text) OWNER TO postgres;
관련 문서
Plugin Backlinks: 아무 것도 없습니다.