You are currently viewing the 0.10 branch api documentation. Switch to 1.0 or 1.1

0.10 Doctrine_Expression_Pgsql

Doctrine Expression Pgsql

Inheritence

Doctrine_Expression_Pgsql  < Doctrine_Expression_Driver  < Doctrine_Connection_Module

Method Summary

Returns Name Description
string age
string concat
string date_part
string matchPattern EXPERIMENTAL WARNING: this function is experimental and may change signature at any time until labelled as non-experimental
string md5 Note: Not SQL92, but common functionality md5() works with the default PostgreSQL 8 versions. If you are using PostgreSQL 7.x or older you need to make sure that the digest procedure is installed. If you use RPMS (Redhat and Mandrake) install the postgr
string now
return random
string regexp
string substring Note: Not SQL92, but common functionality.
string to_char

Methods inherited from Doctrine_Expression_Driver

pi , upper , avg , md5 , add , between , length , ltrim , __call , trim , cos , regexp , not , mul , substring , rtrim , neq , in , mod , now , sum , isNull , sub , lte , sin , gte , count , getIdentifiers , guid , max , eq , getIdentifier , round , lt , gt , div , lower , isNotNull , soundex , concat , acos , locate , min

Method Details

  • $timestamp1 timestamp to subtract from NOW()
    $timestamp2 optional; if given: subtract arguments

    (string) age($timestamp1, $timestamp2 = null)

    PostgreSQLs AGE(<timestamp1> [, <timestamp2>]) function.


  • 0 array of values

    (string) concat((an) 0)

    PostgreSQLs CONCAT() function


  • $text what to extract
    $time timestamp or interval to extract from

    (string) date_part($text, $time)

    PostgreSQLs DATE_PART( <text>, <time> ) function.


  • $pattern even keys are strings, odd are patterns (% and _)
    $operator optional pattern operator (LIKE, ILIKE and maybe others in the future)
    $field optional field name that is being matched against (might be required when emulating ILIKE)

    (string) matchPattern($pattern, $operator = null, $field = null)

    build a pattern matching string

    EXPERIMENTAL
    WARNING: this function is experimental and may change signature at any time until labelled as non-experimental

    Doctrine_Expression_Pgsql


  • (string) md5($column)

    Returns the md5 sum of a field.

    Note: Not SQL92, but common functionality
    md5() works with the default PostgreSQL 8 versions.
    If you are using PostgreSQL 7.x or older you need to make sure that the digest procedure is installed. If you use RPMS (Redhat and Mandrake) install the postgr


  • (string) now()

    Returns the SQL string to return the current system date and time.


  • (return) random()

    return string to call a function to get random value inside an SQL statement

    Doctrine_Expression_Pgsql


  • (string) regexp()

    Doctrine_Expression_Pgsql


  • $value the target $value the string or the string column.
    $from extract from this characeter.
    $len extract this amount of characters.

    (string) substring($value, $from, $len = null)

    Returns part of a string.

    Note: Not SQL92, but common functionality.

    Doctrine_Expression_Pgsql


  • $time timestamp or interval
    $text how to the format the output

    (string) to_char($time, $text)

    PostgreSQLs TO_CHAR( <time>, <text> ) function.