SF.net SVN: ledger-smb:[5769] trunk/sql/modules/Company.sql

[..hidden..]

Revision: 5769
          http://sourceforge.net/p/ledger-smb/code/5769
Author:   einhverfr
Date:     2013-05-11 09:56:25 +0000 (Sat, 11 May 2013)
Log Message:
-----------
Correcting typo in company name starts with search

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

Modified: trunk/sql/modules/Company.sql
===================================================================
--- trunk/sql/modules/Company.sql	2013-05-11 09:49:01 UTC (rev 5768)
+++ trunk/sql/modules/Company.sql	2013-05-11 09:56:25 UTC (rev 5769)
@@ -276,7 +276,7 @@
 		JOIN (SELECT legal_name, sic_code, entity_id 
                         FROM company 
                        WHERE legal_name @@ plainto_tsquery(in_name_part)
-                             OR legal_name ilike 'in_name_part' || '%'
+                             OR legal_name ilike in_name_part || '%'
                       UNION ALL
                       SELECT legal_name, sic_code, entity_id
                         FROM company

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