Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE OR REPLACE FUNCTION totalRecords ()
- RETURNS INTEGER AS $total$
- DECLARE
- total INTEGER;
- BEGIN
- SELECT COUNT(*) INTO total FROM ht_salarycomponent;
- RETURN total;
- END;
- $total$ LANGUAGE plpgsql;
- SELECT totalRecords();
Advertisement
Add Comment
Please, Sign In to add comment