Hello!
I'm trying to create a function that uses this table and for this I'm
using PgAccess/Tcl/Tk:
fields type
empr_tx_matricula varchar
empr_tx_nome varchar
empr_in_perfil int8
The function is:
name : empregado
parameters : int8
returns : varchar
language : sql
body: SELECT empr_tx_nome FROM empregado WHERE empr_in_perfil = $1
The problem is:
At the table, there are several records which empr_in_perfil values are
1, but when I call the function (select empregado(1);) it returns only
one of the records.
What's the solution?
Best regards
Danyele Almeida