From af55cc406515c7ead82fd53d7800351a53e9dc93 Mon Sep 17 00:00:00 2001 From: einhverfr Date: Thu, 8 Mar 2007 19:35:58 +0000 Subject: Fixing bug in employee search due to use of inner instead of left join git-svn-id: https://ledger-smb.svn.sourceforge.net/svnroot/ledger-smb/trunk@867 4979c152-3d1c-0410-bac9-87ea11338e46 --- sql/upgrade/1.2-1.3.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/sql/upgrade/1.2-1.3.sql b/sql/upgrade/1.2-1.3.sql index 77fd43b3..73182815 100644 --- a/sql/upgrade/1.2-1.3.sql +++ b/sql/upgrade/1.2-1.3.sql @@ -151,7 +151,7 @@ $$ language plpgsql; -- as long as we need the datatype, might as well get some other use out of it! CREATE OR REPLACE VIEW employee_search AS SELECT e.*, m.name AS manager -FROM employees e JOIN employees m ON (e.managerid = m.id); +FROM employees e LEFT JOIN employees m ON (e.managerid = m.id); CREATE OR REPLACE FUNCTION employee_search (in_startdatefrom date, in_startdateto date, in_name varchar, in_notes text, -- cgit v1.2.3