Re: PHP PDO getting data from pgSQL stored function

Hi,

sorry for the late response.

I did it with the solution posted by Jonah.

It is not necessary for me to return a table(...) because i want to
return the structure which is already defined in my database so i can
use SETOF RECORD as return type. So i use the real table to define the
return of my function.

PDO select works just like a normal select on a table.

Thank you.

Am 03.11.2013 17:06, schrieb Jonah H. Harris:
> On Sat, Nov 2, 2013 at 11:54 AM, Michael Schmidt <css(dot)liquid(at)gmail(dot)com
> <mailto:css(dot)liquid(at)gmail(dot)com>> wrote:
>
> i need to do a ugly select which i dont want to place in my php code.
> I use PDO all the time.
>
>
> All database access from our application is functionalized using
> either PL/pgSQL or SQL functions.
>
> I want to return a structure which is the same as a table i have
> created.
>
>
> CREATE FUNCTION blah (IN param 1, ..., IN param n, OUT param 1, ...
> OUT param n) RETURNS SETOF RECORD
>
> Now my question, how can i return that and access it with PHP PDO?
> Should I use a cursor or shoul I use the return of the function
> (if it is possible)?
>
>
> Just do a SELECT * FROM blah(...); as a normal PDO query.
>
> --
> Jonah H. Harris
> Blog: http://www.oracle-internals.com/