summaryrefslogtreecommitdiff
path: root/sql/modules/Business_type.sql
blob: af11a9e5d508a4e964d7709f5751a8e574654e0b (plain)
  1. CREATE OR REPLACE FUNCTION business_type__list() RETURNS SETOF business AS
  2. $$
  3. DECLARE out_row business%ROWTYPE;
  4. BEGIN
  5. FOR out_row IN SELECT * FROM business LOOP
  6. RETURN NEXT out_row;
  7. END LOOP;
  8. END;
  9. $$ LANGUAGE PLPGSQL;