PostgreSQL function call model for PHP

A short article on using a class to call PostgreSQL functions:

http://pgedit.com/resource/php/pgfuncall

Comments and suggestions welcome!

John DeSoi, Ph.D.
http://pgedit.com/
Power Tools for PostgreSQL

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

John DeSoi [ Do, 18 Mai 2006 05:03 ] [ ID #1319770 ]

Re: PostgreSQL function call model for PHP

Very nice, you should note it's for PHP5 so you don't confuse those
who've not made it out of PHP4 land. Might I suggest you also look
at a demo using PDO_PGSQL? Not that it would be much different.

Thanks for the good article!

Gavin

On May 17, 2006, at 8:03 PM, John DeSoi wrote:

> A short article on using a class to call PostgreSQL functions:
>
> http://pgedit.com/resource/php/pgfuncall
>
> Comments and suggestions welcome!
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

gmr [ Do, 18 Mai 2006 05:23 ] [ ID #1319771 ]

Re: PostgreSQL function call model for PHP

Doh, I skipped right over your disclaimer about 5.1 and went straight
for the code... Ignore that comment!

Sorry,

Gavin

On May 17, 2006, at 8:03 PM, John DeSoi wrote:

> A short article on using a class to call PostgreSQL functions:
>
> http://pgedit.com/resource/php/pgfuncall
>
> Comments and suggestions welcome!
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

gmr [ Do, 18 Mai 2006 05:25 ] [ ID #1319772 ]

Re: PostgreSQL function call model for PHP

Very nice, you should note it's for PHP5 so you don't confuse those
who've not made it out of PHP4 land. Might I suggest you also look
at a demo using PDO_PGSQL? Not that it would be much different.

Thanks for the good article!

Gavin

On May 17, 2006, at 8:03 PM, John DeSoi wrote:

> A short article on using a class to call PostgreSQL functions:
>
> http://pgedit.com/resource/php/pgfuncall
>
> Comments and suggestions welcome!
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

gmr [ Do, 18 Mai 2006 05:23 ] [ ID #1320439 ]

Re: PostgreSQL function call model for PHP

Doh, I skipped right over your disclaimer about 5.1 and went straight
for the code... Ignore that comment!

Sorry,

Gavin

On May 17, 2006, at 8:03 PM, John DeSoi wrote:

> A short article on using a class to call PostgreSQL functions:
>
> http://pgedit.com/resource/php/pgfuncall
>
> Comments and suggestions welcome!
>
>
> John DeSoi, Ph.D.
> http://pgedit.com/
> Power Tools for PostgreSQL
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: explain analyze is your friend

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

gmr [ Do, 18 Mai 2006 05:25 ] [ ID #1320440 ]