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;

---

관련 문서