Re: Fwd: [PATCH] Save account headers to 'account_header' table (instead of 'account' table)

[John Locke <..hidden..>]

Attaching patch for account_get stored function -- the commit in #3187
doesn't load into my version of postgres.

Cheers,
John

On 05/29/2011 09:53 AM, Erik Huelsmann wrote:
> Hi John,
>
> If you have a moment to check, I'm no longer able to reproduce your
> problems. Since Chris committed fixes in that area, one of them might
> have included the fix to your issue too.
>
> Could you validate that your problem has been resolved so I can close
> the tracker ticket?
>
>
> Thanks in advance!
>
>
> Bye,
>
>
> Erik.
>
>
> ---------- Forwarded message ----------
> From: Chris Travers <..hidden..>
> Date: Sun, May 29, 2011 at 6:42 PM
> Subject: Re: [PATCH] Save account headers to 'account_header' table
> (instead of 'account' table)
> To: Erik Huelsmann <..hidden..>
> Cc: Development discussion for LedgerSMB
> <..hidden..>
>
>
> Committed
>
> ------------------------------------------------------------------------------
> vRanger cuts backup time in half-while increasing security.
> With the market-leading solution for virtual backup and recovery, 
> you get blazing-fast, flexible, and affordable data protection.
> Download your free trial now. 
> http://p.sf.net/sfu/quest-d2dcopy1
> _______________________________________________
> Ledger-smb-devel mailing list
> ..hidden..
> https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel

diff --git sql/modules/Account.sql sql/modules/Account.sql
index a233e3c..b4e0cad 100644
--- sql/modules/Account.sql
+++ sql/modules/Account.sql
@@ -19,7 +19,7 @@ $$ language sql;
 
 CREATE OR REPLACE FUNCTION account_get (in_id int) RETURNS setof chart AS
 $$
-SELECT * from chart where id = in_id and charttype = 'A';
+SELECT * from chart where id = $1 and charttype = 'A';
 $$ LANGUAGE sql;