Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

pgAdmin Funciton Code



The code displayed by pgAdmin, for a function I have created, does not
allow me to recreate the function as I would like. If I run :-

CREATE SCHEMA "Security"
  AUTHORIZATION postgres;

CREATE TABLE "Security"."CentreGroupPolicy"
(
  "CentreGroupPolicyID" bigint NOT NULL
)
WITHOUT OIDS;

CREATE OR REPLACE FUNCTION
"Security"."CentreGroupPolicyDetailsGet1"(INOUT "pCentreGroupPolicyID"
bigint) AS
$BODY$
BEGIN
    SELECT INTO
       "pCentreGroupPolicyID"
       cgp."CentreGroupPolicyID"
    FROM "Security"."CentreGroupPolicy" cgp
    WHERE cgp."CentreGroupPolicyID" = "pCentreGroupPolicyID";
END;
$BODY$
  LANGUAGE 'plpgsql' STABLE;

Then pgAdmin shows me:-

CREATE OR REPLACE FUNCTION
"Security"."CentreGroupPolicyDetailsGet1"(INOUT pCentreGroupPolicyID
bigint) AS
$BODY$
BEGIN
    SELECT INTO
       "pCentreGroupPolicyID"
       cgp."CentreGroupPolicyID"
    FROM "Security"."CentreGroupPolicy" cgp
    WHERE cgp."CentreGroupPolicyID" = "pCentreGroupPolicyID";
END;
$BODY$
  LANGUAGE 'plpgsql' STABLE;

Which does not run.

If instead I use:-

CREATE OR REPLACE FUNCTION
"Security"."CentreGroupPolicyDetailsGet1"(INOUT pCentreGroupPolicyID
bigint) AS
$BODY$
BEGIN
    SELECT INTO
       pCentreGroupPolicyID
       cgp."CentreGroupPolicyID"
    FROM "Security"."CentreGroupPolicy" cgp
    WHERE cgp."CentreGroupPolicyID" = pCentreGroupPolicyID;
END;
$BODY$
  LANGUAGE 'plpgsql' STABLE;

pgAdmin gives me:-

CREATE OR REPLACE FUNCTION
"Security"."CentreGroupPolicyDetailsGet1"(INOUT pcentregrouppolicyid
bigint) AS
$BODY$
BEGIN
    SELECT INTO
       pCentreGroupPolicyID
       cgp."CentreGroupPolicyID"
    FROM "Security"."CentreGroupPolicy" cgp
    WHERE cgp."CentreGroupPolicyID" = pCentreGroupPolicyID;
END;
$BODY$
  LANGUAGE 'plpgsql' STABLE;

and the case no longer matches for the parameter.

Is it possible to make it more consistent?




Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group