```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;
```

{{tag>postgresql function nextval}}