Received: from beiramar.cpatc.embrapa.br (beiramar.cpatc.embrapa.br
	[200.202.141.1])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eBTDmKL95530
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Dec 2000 08:48:21 -0500 (EST)
	(envelope-from danyele@cpatc.embrapa.br)
Received: from cpatc.embrapa.br (desenv.cpatc.embrapa.br [200.202.141.15])
	by beiramar.cpatc.embrapa.br (8.9.3/8.9.3) with ESMTP id KAA23885
	for <pgsql-interfaces@postgresql.org>;
	Fri, 29 Dec 2000 10:48:02 -0300 (EST)
Message-ID: <3A4C8800.B652226A@cpatc.embrapa.br>
Date: Fri, 29 Dec 2000 10:48:01 -0200
From: danyele <danyele@cpatc.embrapa.br>
X-Mailer: Mozilla 4.7 [en] (Win98; I)
X-Accept-Language: en
MIME-Version: 1.0
To: pgsql-interfaces@postgresql.org
Subject: function
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200012/246
X-Sequence-Number: 591

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