How to successfully create a new function?

From: "Moon, James" <moonj(at)pbworld(dot)com>
To: "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: How to successfully create a new function?
Date: 2012-03-29 23:31:28
Message-ID: 7221923B435D4D4AACA028D54C067B666BEE67@AMNYCMSX03.corp.pbwan.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Good day! A little help, please....

Postgresql 8.3
pgAdmin III v.1.8.4

Creating a new function, or modifying an existing function to:

CREATE OR REPLACE FUNCTION "sp_SetScenario"(scen character varying) RETURNS void AS
$BODY$DECLARE
sqlStatement varchar(500);
BEGIN
SET sqlStatement = 'ALTER USER postgres WITH DEFAULT_SCHEMA = $1';
EXEC(sqlStatement);
END;
$BODY$
LANGUAGE 'sql' VOLATILE
COST 100;

Results in a pop-up message:

pgAdminIII
An error has occurred
ERROR: syntax error at or near "varchar"
LINE3: sqlStatement varchar(500);
^

Thank you for your time!

Jim

______________________________________________________________________
NOTICE: This communication and any attachments ("this message") may contain confidential information for the sole use of the intended recipient(s). Any unauthorized use, disclosure, viewing, copying, alteration, dissemination or distribution of, or reliance on this message is strictly prohibited. If you have received this message in error, or you are not an authorized recipient, please notify the sender immediately by replying to this message, delete this message and all copies from your e-mail system and destroy any printed copies.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Andreas Kretschmer 2012-03-30 07:53:07 Re: How to successfully create a new function?
Previous Message Alan Hodgson 2012-03-29 17:25:53 Re: Disruptive corruption of data during an update