From d7c969e461a051692c0e763c4b4a9c98c76065fd Mon Sep 17 00:00:00 2001 From: =?utf8?q?Sven=20Sch=C3=B6ling?= Date: Fri, 11 May 2007 13:23:14 +0000 Subject: [PATCH] leerzeichen die sql anscheinend braucht --- sql/Pg-upgrade2/chart_category_to_sgn.sql | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) 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'')'; -- 2.20.1