Skip site navigation (1) Skip section navigation (2)

function

From: danyele <danyele(at)cpatc(dot)embrapa(dot)br>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: function
Date: 2000-12-29 12:48:01
Message-ID: 3A4C8800.B652226A@cpatc.embrapa.br (view raw or flat)
Thread:
Lists: pgsql-interfaces
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


pgsql-interfaces by date

Next:From: Constantin TeodorescuDate: 2000-12-29 16:09:32
Subject: Re: libpgtcl
Previous:From: danyeleDate: 2000-12-29 10:44:51
Subject: libpgtcl

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group