Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id ACF279FA456 for ; Wed, 6 Dec 2006 09:16:27 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-new, port 10024) with ESMTP id 24912-06 for ; Wed, 6 Dec 2006 09:16:15 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from perth.mailnetwork.co.uk (perth.mailnetwork.co.uk [80.175.28.46]) by postgresql.org (Postfix) with ESMTP id 3F69D9F93E5 for ; Wed, 6 Dec 2006 09:16:20 -0400 (AST) Received: from [213.146.143.243] (port=7498 helo=[172.16.208.165]) by perth.mailnetwork.co.uk with esmtpa (Exim 4.63) (envelope-from ) id 1GrwdH-0008TM-4t; Wed, 06 Dec 2006 13:16:19 +0000 Message-ID: <4576C2F7.6010709@mailnetwork.co.uk> Date: Wed, 06 Dec 2006 13:17:43 +0000 From: "Andy Shellam (Mailing Lists)" User-Agent: Thunderbird 1.5.0.8 (Windows/20061025) MIME-Version: 1.0 To: Ganesh Laxmanmurthy CC: pgsql-php@postgresql.org Subject: Re: PLPGSQL - PHP data querying References: <938994.73369.qm@web8504.mail.in.yahoo.com> In-Reply-To: <938994.73369.qm@web8504.mail.in.yahoo.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200612/14 X-Sequence-Number: 3682 Why do you specifically want to do this through PlPgsql? You can just as easily do a query directly from PHP to get a recordset, and it gives less server overhead. Andy. Ganesh Laxmanmurthy wrote: > 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/ > > ---------------------------(end of broadcast)--------------------------- > TIP 2: Don't 'kill -9' the postmaster > > !DSPAM:37,45769b3640411164512130! > > > -- Andy Shellam NetServe Support Team the Mail Network "an alternative in a standardised world" p: +44 (0) 121 288 0832/0839 m: +44 (0) 7818 000834