From: Gustavo Tadao Okida <Gtadaodev@netscape.net>
To: pgsql-sql@postgresql.org
Subject: PL/pgsql
Date: Wed, 25 Sep 2002 16:38:59 -0300
Message-ID: <3D9210D3.9030508@netscape.net> (raw)
Hi,
I'm a new PostgreSql user but I have some experience in Oracle. So I
decided to use PL/pgsql to build my procedure (functions).
I create an database called MyDatabase and add this language into it
with: createlang plpgsql MyDatabase. After this, I wrote a function with
pgaccess :
Name: spi_novo_parametro paramters:
returns: char language: plpgsql
DECLARE
val INTEGER :=1;
BEGIN
insert into identificador_pri values(1, "OK");
RETURN "OK";
END;
It was OK when I saved it in pgaccess front end.
When I tested it, by query tab, writing select spi_novo_parametro();, it
return me this message:
Error: can't read
"PgAcVar(mw,.pgaw:22,nrecs)": no such element in array
and the stack is:
Error: can't read "PgAcVar(mw,$wn,nrecs)": no such element in array
while executing
"For {set row 0} {$row<$PgAcVar(mw,$wn,nrecs)} {incr row}{
if {[lindex $PgAcVar(mw,$wn,nrecs) $row]>$y} break }"
(procedure "Tables::canvasClick" line 5)
invoked from within
"Tables::canvasClick .pgaw:22 229 240"
(command bound to event)
Could you help me?
Thanks in advance.
Tadao
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: Gtadaodev@netscape.net
Subject: Re: PL/pgsql
In-Reply-To: <3D9210D3.9030508@netscape.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox