WordPress.org
Get WordPress

Plugin Directory

Changeset 542064


Ignore:
Timestamp:
05/09/2012 08:59:27 PM (14 years ago)
Author:
hawk__
Message:

Added a handle for converting CAST(... AS CHAR) to CAST(... AS TEXT) (Problem pointed out by Aart Jan)

File:
1 edited

Legend:

Unmodified
Added
Removed

  • postgresql-for-wordpress/trunk/pg4wp/driver_pgsql.php

    r542049 r542064  
    202202            }
    203203           
     204            // Handle CAST( ... AS CHAR)
     205            $sql = preg_replace( '/CAST\((.+) AS CHAR\)/', 'CAST($1 AS TEXT)', $sql);
     206           
    204207            // Handle COUNT(*)...ORDER BY...
    205208            $sql = preg_replace( '/COUNT(.+)ORDER BY.+/', 'COUNT$1', $sql);
Note: See TracChangeset for help on using the changeset viewer.