File: Business_type.sql

package info (click to toggle)
ledgersmb 1.6.33%2Bds-2.1
  • links: PTS, VCS
  • area: main
  • in suites: bookworm
  • size: 33,000 kB
  • sloc: perl: 52,612; sql: 43,562; xml: 36,194; javascript: 2,428; sh: 1,099; makefile: 361; pascal: 25
file content (17 lines) | stat: -rw-r--r-- 402 bytes parent folder | download | duplicates (3) 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
 

set client_min_messages = 'warning';


BEGIN;

CREATE OR REPLACE FUNCTION business_type__list() RETURNS SETOF business AS
$$
        SELECT * FROM business ORDER BY description;
$$ LANGUAGE SQL;

COMMENT ON function business_type__list() IS
$$Returns a list of all business types. Ordered by description by default.$$;

update defaults set value = 'yes' where setting_key = 'module_load_ok';

COMMIT;