diff options
| author | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-03-08 19:35:58 +0000 |
|---|---|---|
| committer | einhverfr <einhverfr@4979c152-3d1c-0410-bac9-87ea11338e46> | 2007-03-08 19:35:58 +0000 |
| commit | af55cc406515c7ead82fd53d7800351a53e9dc93 (patch) | |
| tree | 16935cba375626d3fdb51e451f3317cd50334925 | |
| parent | 91c7ac3db95a85457522e26eb70ffd1e75ec8c16 (diff) | |
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
| -rw-r--r-- | sql/upgrade/1.2-1.3.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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, |