How do I fetch a stored postgres function from php

Question

Just a little confused here...

I have a function in postgres, and when I'm at the pg prompt, I just do:

SELECT zp('zc',10,20,90);
FETCH ALL FROM zc;

I'm wondering how to do this from php?

I thought I could just do:

$q = pg_query("SELECT zp('zc',10,20,90)");

But, how do I "fetch" from that query?

Frank Heikens · Accepted Answer · 2010-03-29 08:58:27Z

0

Just send the FETCH-query to the database:

$result = pg_query("FETCH ALL FROM zc;");

You can now use a while-loop to fetch all the results in $result or just just pg_fetch_all() to fetch in PHP.

answered Mar 29, 2010 at 8:58

Frank Heikens

129k26 gold badges157 silver badges153 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

I see... So, I put in both queries? First, the function call, and then the fetch?

Looks like your function returns a cursor, so you need two queries to receive the result.

Ok, thanks. I appreciate the guidance and the ability to dumb things down for a newb. :)