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