X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 220BFD1B211 for ; Mon, 31 May 2004 11:19:49 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 11017-05 for ; Mon, 31 May 2004 11:19:50 -0300 (ADT) Received: from hotmail.com (bay8-f13.bay8.hotmail.com [64.4.27.13]) by svr1.postgresql.org (Postfix) with ESMTP id C5602D1B257 for ; Mon, 31 May 2004 11:19:45 -0300 (ADT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Mon, 31 May 2004 07:19:50 -0700 Received: from 69.65.137.210 by by8fd.bay8.hotmail.msn.com with HTTP; Mon, 31 May 2004 14:19:49 GMT X-Originating-IP: [69.65.137.210] X-Originating-Email: [el_vigia_ec@hotmail.com] X-Sender: el_vigia_ec@hotmail.com From: "Jaime Casanova" To: pgsql-sql@postgresql.org Subject: joining a table with a function Date: Mon, 31 May 2004 14:19:49 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 31 May 2004 14:19:50.0096 (UTC) FILETIME=[556A2D00:01C4471A] X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/224 X-Sequence-Number: 17938 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