From: | Ian Turner <vectro(at)pipeline(dot)com> |
---|---|
To: | pgsql-general(at)hub(dot)org |
Cc: | iant(at)brainstorm(dot)net |
Subject: | function language type? |
Date: | 2000-07-25 05:37:10 |
Message-ID: | Pine.LNX.4.21.0007242232470.1667-100000@crafter.house |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
I am trying to write a function in the SQL procedural language. But when I
use type plpgsql, as the user's guide says, I get this error:
ERROR: Unrecognized language specified in a CREATE FUNCTION: 'plpgsql'.
Recognized languages are sql, C, internal and the created procedural
languages.
If I try setting the language to type sql, I get:
ERROR: parser: parse error at or near "alias"
The only occurance of the string alias is in these four lines, which are
below a DECLARE line, which is the first line of the function:
osec ALIAS FOR $1;
dsec ALIAS FOR $2;
who ALIAS FOR $3;
avoids ALIAS FOR $4;
And yes, the function has four parameters.
Any ideas?
Ian
P.S. Please keep the CC on this message, I want replies at both mailboxes.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.1 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE5fSeJfn9ub9ZE1xoRAkshAJ9zzq3oq2Qu4NsICfNJmwelA58/YgCfcFyc
KjcG5GHUjCZOeXlURbDOqk4=
=Gn4j
-----END PGP SIGNATURE-----
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2000-07-25 05:44:37 | Re: 4 billion record limit? |
Previous Message | Chris Bitmead | 2000-07-25 04:20:35 | Re: ROLLBACK automatically |