From 4dc9e97ad999bb6ea4fe5171be988ee8e6c156dc Mon Sep 17 00:00:00 2001 From: einhverfr Date: Fri, 12 Sep 2008 23:36:59 +0000 Subject: Adding drop down box to set primary entity class for companies. git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@2323 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/modules/Entity.sql | 13 +++++++++++++ 1 file changed, 13 insertions(+) (limited to 'sql') diff --git a/sql/modules/Entity.sql b/sql/modules/Entity.sql index 71eca451..9f7a5ac8 100644 --- a/sql/modules/Entity.sql +++ b/sql/modules/Entity.sql @@ -37,6 +37,19 @@ CREATE OR REPLACE FUNCTION entity_save( $$ language 'plpgsql'; +CREATE OR REPLACE FUNCTION entity__list_classes () +RETURNS SETOF entity_class AS $$ +DECLARE out_row entity_class; +BEGIN + FOR out_row IN + SELECT * FROM entity_class + WHERE active + ORDER BY id + LOOP + RETURN NEXT out_row; + END LOOP; +END; +$$ LANGUAGE PLPGSQL; CREATE OR REPLACE FUNCTION entity__get_entity ( in_entity_id int -- cgit v1.2.3