Comment 1984 added to page plpgsql.html of version 7.4

From: nobody <nobody(at)developer(dot)pgadmin(dot)org>
To: pgsql-www(at)postgresql(dot)org
Subject: Comment 1984 added to page plpgsql.html of version 7.4
Date: 2005-01-12 02:52:22
Message-ID: 200501120252.j0C2qMIk008234@developer.pgadmin.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-www

Author: James Nakasone Wong <janaka_tech(at)bluebottle(dot)com>
----
=====================
CREATE FUNCTION somefunc() RETURNS integer AS '
DECLARE
quantity integer := 30;
BEGIN
RAISE NOTICE ''Quantity here is %'', quantity; -- Quantity here is 30
quantity := 50;
--
-- Create a subblock
--
DECLARE
quantity integer := 80;
BEGIN
RAISE NOTICE ''Quantity here is %'', quantity; -- Quantity here is 80
END;

RAISE NOTICE ''Quantity here is %'', quantity; -- Quantity here is 50

RETURN quantity;
END;
' LANGUAGE plpgsql;

==============================
I 've saved above text in f2.sql
then when I upload this file (f2.sql) an error appeared? can anybody advice what shall I need to do from there ?

============================
test=# \i f2.sql
psql:f2.sql:20: ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.
test=#
----
Manual page: http://wwwmaster.postgresql.org/docs/7.4/interactive/plpgsql.html
Reject: http://wwwmaster.postgresql.org/admin/comments.php?action=reject&id=1984
Edit: http://wwwmaster.postgresql.org/admin/comment-edit.php?id=1984
Delete: http://wwwmaster.postgresql.org/admin/comments.php?action=delete&id=1984

Browse pgsql-www by date

  From Date Subject
Next Message Marc G. Fournier 2005-01-12 04:43:09 Nagios and SMS Paging ...
Previous Message Josh Berkus 2005-01-11 21:56:05 Re: 64-bit mirrors