SF.net SVN: ledger-smb:[4056] branches/1.3/sql/modules/Person.sql

[..hidden..]

Revision: 4056
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=4056&view=rev
Author:   tshvr
Date:     2011-11-24 19:23:16 +0000 (Thu, 24 Nov 2011)
Log Message:
-----------
new function person__list_languages

Modified Paths:
--------------
    branches/1.3/sql/modules/Person.sql

Modified: branches/1.3/sql/modules/Person.sql
===================================================================
--- branches/1.3/sql/modules/Person.sql	2011-11-24 19:13:55 UTC (rev 4055)
+++ branches/1.3/sql/modules/Person.sql	2011-11-24 19:23:16 UTC (rev 4056)
@@ -12,6 +12,11 @@
 COMMENT ON FUNCTION person__get_my_entity_id() IS
 $$ Returns the entity_id of the current, logged in user.$$;
 
+CREATE OR REPLACE FUNCTION person__list_languages() 
+RETURNS SETOF language AS
+$$ SELECT * FROM language ORDER BY code ASC $$ language sql;
+COMMENT ON FUNCTION person__list_languages() IS
+$$ Returns a list of languages ordered by code$$;
 
 CREATE OR REPLACE FUNCTION person__list_salutations() 
 RETURNS SETOF salutation AS

This was sent by the SourceForge.net collaborative development platform, the world's largest Open Source development site.