PL/pgsql
От | Gustavo Tadao Okida |
---|---|
Тема | PL/pgsql |
Дата | |
Msg-id | 3D9210D3.9030508@netscape.net обсуждение исходный текст |
Ответы |
Re: PL/pgsql
|
Список | pgsql-sql |
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
В списке pgsql-sql по дате отправления: