From: danyele <danyele@cpatc.embrapa.br>
To: pgsql-interfaces@postgresql.org
Subject: function
Date: Fri, 29 Dec 2000 10:48:01 -0200
Message-ID: <3A4C8800.B652226A@cpatc.embrapa.br> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: danyele@cpatc.embrapa.br
Subject: Re: function
In-Reply-To: <3A4C8800.B652226A@cpatc.embrapa.br>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox