Unable to run one pl/pgSQL function :-(
Hello,
I've written a little pl/pgSQL function in order to use it on a little
postgreSQL database :
CREATE function tuple_add(VARCHAR(200)) RETURNS text AS
'
DECLARE
Response text;
PeopleName ALIAS FOR $1;
BEGIN
INSERT INTO PEOPLES VALUES (SEQUENCE_Id.NEXTVAL(),PeopleName);
return Response;
END;
' LANGUAGE 'plpgsql';
When I add this function to my database, I don't receive any error
message.
But I don't success to use this function. I've tried like that :
mabd=> SELECT tuple_add('One try');
ERROR: parser: parse error at or near "("
mabd=> SELECT tuple_add("One try");
ERROR: Attribute 'One try' not found
The PEOPLE database just contains two columns : an INTEGER and one
VARCHAR(200). And the SEQUENCE_Id sequence I use is existing. I've also
checked that pl/pgSQL has been activated to my database.
The Response variable is to be used to get the eventual exception, but I
have to find how I can do that.
Can you explain me how can I use my pl/pgSQL function ?
Thanks in advance ! :-)
-------------------------------------------------
Bruno BAGUETTE - bruno.baguette@netcourrier.com
Postgres is case sensitive you should try to put all your table names within
"" (Double Quotes)
INSERT INTO "PEOPLES" VALUES ("SEQUENCE_Id".nextval(),''PeopleName'');
the '' around PeopleName is 2 single '
I hope this helps
----- Original Message -----
From: "Bruno Baguette" <bruno.baguette@netcourrier.com>
To: <pgsql-general@postgresql.org>
Sent: Friday, June 21, 2002 7:34 PM
Subject: [GENERAL] Unable to run one pl/pgSQL function :-(
Show quoted text
Hello,
I've written a little pl/pgSQL function in order to use it on a little
postgreSQL database :CREATE function tuple_add(VARCHAR(200)) RETURNS text AS
'
DECLARE
Response text;
PeopleName ALIAS FOR $1;
BEGIN
INSERT INTO PEOPLES VALUES (SEQUENCE_Id.NEXTVAL(),PeopleName);
return Response;
END;
' LANGUAGE 'plpgsql';When I add this function to my database, I don't receive any error
message.But I don't success to use this function. I've tried like that :
mabd=> SELECT tuple_add('One try');
ERROR: parser: parse error at or near "("
mabd=> SELECT tuple_add("One try");
ERROR: Attribute 'One try' not foundThe PEOPLE database just contains two columns : an INTEGER and one
VARCHAR(200). And the SEQUENCE_Id sequence I use is existing. I've also
checked that pl/pgSQL has been activated to my database.The Response variable is to be used to get the eventual exception, but I
have to find how I can do that.Can you explain me how can I use my pl/pgSQL function ?
Thanks in advance ! :-)
-------------------------------------------------
Bruno BAGUETTE - bruno.baguette@netcourrier.com---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly