X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id EA5C83A4979 for ; Fri, 26 Nov 2004 06:42:12 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 23783-05 for ; Fri, 26 Nov 2004 06:42:01 +0000 (GMT) Received: from web50010.mail.yahoo.com (web50010.mail.yahoo.com [206.190.38.25]) by svr1.postgresql.org (Postfix) with SMTP id 6F8423A4783 for ; Fri, 26 Nov 2004 06:42:00 +0000 (GMT) Received: (qmail 67364 invoked by uid 60001); 26 Nov 2004 06:41:59 -0000 Comment: DomainKeys? See http://antispam.yahoo.com/domainkeys DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; b=wTpadEGSaQNWK32Pj62TQQlpPvMm7IcBmFKSN0XZWMegeVXl9DMAy5xZuTU3sUf8MmmaVBn1RCPEHQ7XSMDKs5MHkC2Zk0bK/zbR9CkjFVlAuyhaclKYGfUptpGqGIqmBIUGhiIjhHmqeIEKSN51ZEWMniEKGQ2WKbACykDTlfg= ; Message-ID: <20041126064158.67362.qmail@web50010.mail.yahoo.com> Received: from [200.93.192.137] by web50010.mail.yahoo.com via HTTP; Fri, 26 Nov 2004 00:41:58 CST Date: Fri, 26 Nov 2004 00:41:58 -0600 (CST) From: Jaime Casanova Subject: select with a function To: sql pgsql MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200411/260 X-Sequence-Number: 19578 Hi all, i need some help i wanna do a select with a function call like this: SELECT academico.aca_f_siguientecurso( academico.aca_t_alumnocurso.ent_codigo, academico.aca_t_alumnocurso.sec_codigo, academico.aca_t_alumnocurso.ani_codigo, academico.aca_t_alumnocurso.cic_codigo, academico.aca_t_alumnocurso.esp_codigo, academico.aca_t_alumnocurso.cur_codigo, academico.aca_t_alumnocurso.cur_paralelo, academico.aca_t_alumnocurso.est_codigo), NULL as asp_codigo, academico.aca_t_alumnocurso.alu_codigo FROM academico.aca_t_alumnocurso WHERE academico.aca_t_alumnocurso.est_codigo IN ('AP', 'RP', 'RT'); the function academico.aca_f_siguientecurso returns a custom type (a record). ok, in the IRC AndrewSN told me this won't work in a pre 8 pgsql, so i will need do it in a subselect but the function has to be called once per row in academico.aca_t_alumnocurso that matches the where. but I don't know any easy way of doing that for each row in a query. any ideas? regards, Jaime Casanova _________________________________________________________ Do You Yahoo!? Información de Estados Unidos y América Latina, en Yahoo! Noticias. Visítanos en http://noticias.espanol.yahoo.com