X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fchart_category_to_sgn.sql;h=c03d4203ecee98436bbc3fecd942e07867915740;hb=f15f5e4321df31d2279edb480e9c7fc15c3af31c;hp=20360d28f750fe73ba8d74b75f9e0fa56909a081;hpb=7679dfa4ba64c4cc24a027fa5bdfd5e616ca92a8;p=kivitendo-erp.git diff --git a/sql/Pg-upgrade2/chart_category_to_sgn.sql b/sql/Pg-upgrade2/chart_category_to_sgn.sql index 20360d28f..c03d4203e 100644 --- a/sql/Pg-upgrade2/chart_category_to_sgn.sql +++ b/sql/Pg-upgrade2/chart_category_to_sgn.sql @@ -2,10 +2,10 @@ -- @description: Fuegt eine Hilfsfunktion ein mit der die interne Reprasentation der Konten (Haben positiv) in die Mehrungsrepraesentation gewandelt werden kann. -- @depends: -CREATE OR REPLACE FUNCTION chart_category_to_sgn(CHARACTER(1)) -RETURNS INTEGER -LANGUAGE SQL -AS 'SELECT 1 WHERE $1 IN (''I'', ''L'', ''Q'') + CREATE OR REPLACE FUNCTION chart_category_to_sgn(CHARACTER(1)) + RETURNS INTEGER + LANGUAGE SQL + AS 'SELECT 1 WHERE $1 IN (''I'', ''L'', ''Q'') UNION SELECT -1 WHERE $1 IN (''E'', ''A'')';