SF.net SVN: ledger-smb:[3014] trunk/sql/modules/Account.sql

[..hidden..]

Revision: 3014
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=3014&view=rev
Author:   einhverfr
Date:     2010-06-26 22:11:06 +0000 (Sat, 26 Jun 2010)

Log Message:
-----------
committing refactoring for account.sql 

Modified Paths:
--------------
    trunk/sql/modules/Account.sql

Modified: trunk/sql/modules/Account.sql
===================================================================
--- trunk/sql/modules/Account.sql	2010-06-26 22:07:52 UTC (rev 3013)
+++ trunk/sql/modules/Account.sql	2010-06-26 22:11:06 UTC (rev 3014)
@@ -163,3 +163,9 @@
         -- Already found, no need to do anything. =) 
     END;
 $BODY$ LANGUAGE PLPGSQL;
+
+CREATE OR REPLACE FUNCTION account__get_by_link_desc(in_description text)
+RETURNS SETOF account AS $$
+SELECT * FROM account
+WHERE id IN (SELECT account_id FROM account_link WHERE description = $1);
+$$ language sql;


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