From: Jaime Casanova <el_vigia_ec@hotmail.com>
To: pgsql-sql@postgresql.org
Subject: joining a table with a function
Date: Mon, 31 May 2004 14:19:49 +0000
Message-ID: <BAY8-F13ZYNX6Mma0n70001af8a@hotmail.com> (raw)
hi all,
i have a function of a user defined type it returns a record of values but
just a row.
select * from rec_f_consultar_alumno(a.ent_codigo, a.alu_codigo)
what i want to do now is a select in wich i can do a seq scan or an index
scan of a table and
pass the values i retrieve into the function. the select have to retrieve
the result of the function.
i can do that whit a function with setof but i want to know if it is
possible to do it with a select
_________________________________________________________________
Add photos to your messages with MSN 8. Get 2 months FREE*.
http://join.msn.com/?page=features/featuredemail
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: el_vigia_ec@hotmail.com
Subject: Re: joining a table with a function
In-Reply-To: <BAY8-F13ZYNX6Mma0n70001af8a@hotmail.com>
* 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