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

[..hidden..]

Revision: 2779
          http://ledger-smb.svn.sourceforge.net/ledger-smb/?rev=2779&view=rev
Author:   einhverfr
Date:     2009-11-05 20:43:24 +0000 (Thu, 05 Nov 2009)

Log Message:
-----------
Correcting account api

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

Modified: trunk/sql/modules/Account.sql
===================================================================
--- trunk/sql/modules/Account.sql	2009-10-28 19:33:59 UTC (rev 2778)
+++ trunk/sql/modules/Account.sql	2009-11-05 20:43:24 UTC (rev 2779)
@@ -1,5 +1,11 @@
 -- VERSION 1.3.0
 
+CREATE OR REPLACE FUNCTION account__get_from_accno(in_accno text)
+returns account as
+$$
+     select * from account where accno = $1;
+$$ language sql;
+
 CREATE OR REPLACE FUNCTION account_get (in_id int) RETURNS chart AS
 $$
 DECLARE


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