From: Paulo Nievierowski <postgres@steffenpneus.com.br>
To: pgsql-sql@postgresql.org
Subject: SELECT with Function
Date: Wed, 29 Sep 2004 10:51:49 -0300
Message-ID: <2004929105149.835585@develop> (raw)
Hello,
This is my first message to pgsql-novice.
I create plpgsql function "myfunc(integer)" thats returns of type
record with values from table X (the function decides what record must
be select). The parameter is an keyprod existing in table X and in
table A.
It run well sending in psql:
SELECT * FROM myfunc( 10006530 ) as (vret1 numeric, vret2 numeric);
The problem is:
I need return data from table A (this have column 'keyprod'). This
value (keyprod) must be passed as parameter to myfunc(). The result
must be a union of columns selected from table A and result of
myfunc().
How to create this query? It's possible?
Thanks
Paulo Nievierowski
PS: Excuses my poor english.
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-sql@postgresql.org
Cc: postgres@steffenpneus.com.br
Subject: Re: SELECT with Function
In-Reply-To: <2004929105149.835585@develop>
* 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