| From: | "Jaime Casanova" <el_vigia_ec(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | joining a table with a function |
| Date: | 2004-05-31 14:19:49 |
| Message-ID: | BAY8-F13ZYNX6Mma0n70001af8a@hotmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-06-01 02:05:11 | Re: insert or update violates foreign key constraint.why? |
| Previous Message | sad | 2004-05-31 07:52:42 | type regclass casting |