[pgadmin-support] This function doesn't shown in pgAdmin III, but does in pgAdmin II

[Dieter Fischer]

Hello

This is what I get in Version 3:

<SNIP>
-- Function: cobra.code_gebiet(varchar, int4, int4, int4)

-- DROP FUNCTION cobra.code_gebiet(varchar, int4, int4, int4);

CREATE OR REPLACE FUNCTION cobra.code_gebiet(varchar, int4, int4, int4)
  RETURNS varchar AS
''
  LANGUAGE 'plpgsql' VOLATILE;
</SNIP>

in Version 2 I get this (which is correct and also in the PG_DUMP):

<SNIP>
Create Or Replace Function cobra.code_gebiet(varchar,int4,int4,int4)
Returns varchar As '

--
************************************************************************
******
-- Ver    Datum       Autor  �nderung
-- -----  ----------  -----  ------------------------------------
-- 1.0    017.03.20023 df     Erstellt
--
************************************************************************
******
-- Beschreibung:
--
-- Holt den Code aus der Code-Tabelle. Falls die Sprache nicht existiert
ist der
-- Fallback Deutsch. Wenn auch Deutsch nicht existiert --> Fehler
--
************************************************************************
******
DECLARE
   gebiet_i     ALIAS FOR $1;
   code_i       ALIAS FOR $2;
   spr_i        ALIAS FOR $3;
   short_i      ALIAS FOR $4;

   bez_         codetext.bez%TYPE;
   kbez_        codetext.kbez%TYPE;
   --
   true_        CONSTANT INTEGER  := 1;
   false_       CONSTANT INTEGER  := 0;
   errm_        VARCHAR(2000);
BEGIN
   SELECT       cote.kbez,      cote.bez
   INTO         kbez_,          bez_
   FROM         codetext_v      cote,
                code_v          code
   WHERE        code.gebiet   = UPPER(gebiet_i)
   AND          code.code     = code_i
   AND          cote.code_seq = code.code_seq
   AND          cote.spr_code = spr_i;

   IF short_i = true_ THEN
      RETURN(kbez_);
   ELSE
      RETURN(bez_);
   END IF;

   IF NOT FOUND THEN  -- If nothing was returned in the last query
      SELECT    cote.kbez,      cote.bez
      INTO      kbez_,          bez_
      FROM      codetext_v      cote,
                code_v          code
      WHERE     code.gebiet   = UPPER(gebiet_i)
      AND       code.code     = code_i
      AND       cote.code_seq = code.code_seq
      AND       cote.spr_code = 1;        -- Fix Deutsch

      IF NOT FOUND THEN  -- If nothing was returned in the last query
         errm_ := ''code_sprache: Code not found, GEBIET=''||
                   gebiet_||'', CODE=''||code_i;
         RETURN(errm_);
      ELSE
         IF short_i = true_ THEN
            RETURN(kbez_);
         ELSE
            RETURN(bez_);
         END IF;
      END IF;

   END IF;

END;
'
Language 'plpgsql';
</SNIP>

Any ideas?

Versions:

PgAdmin III:    1.0.0
PostgreSQL:             7.3.3

Regards

Dieter


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])