Cakephp pagination and Linkable behavior is Not working in Postgres (have to modify behavior to fix it).

[phpcoder2011]

Hi. I think that this will not work in postgres. But it is probably easy to fix. For those who have an issue go to linkable behavior class and change every record like this

"elseif($query['fields'] != 'COUNT(*) AS count') {"

to something like this:

"elseif(strpos($query['fields'], 'COUNT(*)') === false) {"

[Terr]

I have absolutely no experience with setting up a Postgres server, so it's not easy for me to test a fix. Would you be able to provide a tested patch?