X-Git-Url: http://wagnertech.de/git?a=blobdiff_plain;f=sql%2FPg-upgrade2%2Fchart_category_to_sgn.sql;h=c03d4203ecee98436bbc3fecd942e07867915740;hb=e4b4e4d3dd4b1e85212b9e061ff4c659ed02d8b8;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'')';