Обсуждение: function

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