1SearchBuilder::Handle::UPsge(r3)Contributed Perl DocumenSteaatricohnBuilder::Handle::Pg(3)
2
3
4

NAME

6         DBIx::SearchBuilder::Handle::Pg - A Postgres specific Handle object
7

SYNOPSIS

DESCRIPTION
10       This module provides a subclass of DBIx::SearchBuilder::Handle that
11       compensates for some of the idiosyncrasies of Postgres.
12

METHODS
14       Connect
15
16       Connect takes a hashref and passes it off to SUPER::Connect; Forces the
17       timezone to GMT it returns a database handle.
18
19       Insert
20
21       Takes a table name as the first argument and assumes that the rest of
22       the arguments are an array of key-value pairs to be inserted.
23
24       In case of insert failure, returns a Class::ReturnValue object pre‐
25       loaded with error info.
26
27       InsertQueryString
28
29       Postgres sepcific overriding method for "InsertQueryString" in
30       DBIx::SearchBuilder::Handle.
31
32       IdSequenceName TABLE
33
34       Takes a TABLE name and returns the name of the  sequence of the primary
35       key for that table.
36
37       BinarySafeBLOBs
38
39       Return undef, as no current version of postgres supports binary-safe
40       blobs
41
42       ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
43
44       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE
45       starting with FIRST_ROW;
46
47       _MakeClauseCaseInsensitive FIELD OPERATOR VALUE
48
49       Takes a field, operator and value. performs the magic necessary to make
50       your database treat this clause as case insensitive.
51
52       Returns a FIELD OPERATOR VALUE triple.
53
54       DistinctQuery STATEMENTREF
55
56       takes an incomplete SQL SELECT statement and massages it to return a
57       DISTINCT result set.
58

SEE ALSO
60       DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
61
62
63
64perl v5.8.8                       2007-02-17      SearchBuilder::Handle::Pg(3)



        

    


            
        

        

            Impressum