X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 46DFEDB509 for ; Mon, 31 Oct 2005 12:43:45 -0400 (AST) 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 57955-09 for ; Mon, 31 Oct 2005 16:43:42 +0000 (GMT) Received: from elettra.trieste.it (mail2.elettra.trieste.it [140.105.4.202]) by svr1.postgresql.org (Postfix) with ESMTP id 86511DB237 for ; Mon, 31 Oct 2005 12:43:40 -0400 (AST) Received: from [140.105.3.203] (account alessandro.busato HELO [140.105.3.203]) by elettra.trieste.it (CommuniGate Pro SMTP 4.3.8) with ESMTPA id 10128773 for pgsql-sql@postgresql.org; Mon, 31 Oct 2005 17:44:29 +0100 Message-ID: <436657B7.80705@elettra.trieste.it> Date: Mon, 31 Oct 2005 17:43:19 +0000 From: Alessandro Busato User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: pgSQL, executing generic query Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: X-Archive-Number: 200510/397 X-Sequence-Number: 23250 Hi, I should to write a function which has one text parameter ; throught this parameter a query will be passed to the function; in the function the query will be executed and the result put in the record type; the problem is: how can I to get the columns value if the query is not defined a priori? i.e. I can't use the contruct "record".fieldname I've searched everywhere but nothing. is it possible with pgSQL? have you any suggest? Thanks, Alessandro