Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0AD249F9FDA for ; Wed, 6 Dec 2006 06:27:44 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 40909-06 for ; Wed, 6 Dec 2006 06:27:36 -0400 (AST) X-Greylist: delayed 00:06:39.340313 by SQLgrey-1.7.4 Received: from web8504.mail.in.yahoo.com (web8504.mail.in.yahoo.com [202.43.219.166]) by postgresql.org (Postfix) with SMTP id 562D29F9F49 for ; Wed, 6 Dec 2006 06:27:39 -0400 (AST) Received: (qmail 74607 invoked by uid 60001); 6 Dec 2006 10:20:57 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=wQF7IrkG/oGOQ4AWlHKIwOkFJhGTbMITb7yZ52jxeQribXcyazxjmK8GKGfz1oHoMMtk9YlWP+QX+B/WxN6FAi5zys653cVjbzuAQ3aQ7XmF3KWoSKAAVdVAetTMpFc+Q5z4MDSL9Dgi4RX8kLb8Wvtp3nWHpzlOTz0RdLrUVXM=; X-YMail-OSG: 2K2SBDIVM1krS6WZwPoWulvZOW0IljBOoj3vlHW8YhpKCwpZokjiI6yzUVusJ4UNUCdlsArIzjZJsVBJo3_rpDZdf4h_SyVsjXV_Nfs2Z66gmj21HODmBBXg.p3j62kX3JYWb2ZvS0M6j_LGStRib918GmEk2G3ubQ-- Received: from [125.22.50.174] by web8504.mail.in.yahoo.com via HTTP; Wed, 06 Dec 2006 10:20:56 GMT Date: Wed, 6 Dec 2006 10:20:56 +0000 (GMT) From: Ganesh Laxmanmurthy Subject: PLPGSQL - PHP data querying To: pgsql-php@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <938994.73369.qm@web8504.mail.in.yahoo.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.909 tagged_above=0 required=5 tests=BAYES_50, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST X-Spam-Level: * X-Archive-Number: 200612/12 X-Sequence-Number: 3680 Dear All: Regarding PHP & PLPGSQL Programming. I am new to PLPGSQL. I wish someone suggest me the solution for the below requirement even though it is very simple as I am new to the subject and could not find an answer which I can understand. I have a table by name 'users' with several columns. I want to query "select * from users' from PHP to Postgresql through PLPGSQL. Therefore I need 1. The practical syntax for the PLPGSQL function 2. The practical syntax for calling and displaying of the returned recordset from PHP. With the above I would be able to develop futher programs. I would be thankful for the same. Thanks in advance Regards Ganesh __________________________________________________________ Yahoo! India Answers: Share what you know. Learn something new http://in.answers.yahoo.com/