Message-ID: <3D9210D3.9030508@netscape.net>
Date: Wed, 25 Sep 2002 16:38:59 -0300
From: Gustavo Tadao Okida <Gtadaodev@netscape.net>
User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US;
	rv:1.0.1) Gecko/20020823 Netscape/7.0
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: PL/pgsql
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

    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