1DBIx::SearchBuilder::HaUnsdelre:C:oPngt(r3i)buted Perl DDoBcIuxm:e:nSteaatricohnBuilder::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       Connect takes a hashref and passes it off to SUPER::Connect; Forces the
16       timezone to GMT it returns a database handle.
17
18   Insert
19       Takes a table name as the first argument and assumes that the rest of
20       the arguments are an array of key-value pairs to be inserted.
21
22       In case of insert failure, returns a Class::ReturnValue object
23       preloaded with error info.
24
25   InsertQueryString
26       Postgres sepcific overriding method for "InsertQueryString" in
27       DBIx::SearchBuilder::Handle.
28
29   IdSequenceName TABLE
30       Takes a TABLE name and returns the name of the  sequence of the primary
31       key for that table.
32
33   BinarySafeBLOBs
34       Return undef, as no current version of postgres supports binary-safe
35       blobs
36
37   ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
38       takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE
39       starting with FIRST_ROW;
40
41   _MakeClauseCaseInsensitive FIELD OPERATOR VALUE
42       Takes a field, operator and value. performs the magic necessary to make
43       your database treat this clause as case insensitive.
44
45       Returns a FIELD OPERATOR VALUE triple.
46
47   DistinctQuery STATEMENTREF
48       takes an incomplete SQL SELECT statement and massages it to return a
49       DISTINCT result set.
50
51   SimpleDateTimeFunctions
52       Returns hash reference with specific date time functions of this
53       database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
54
55   ConvertTimezoneFunction
56       Custom implementation of "ConvertTimezoneFunction" in
57       DBIx::SearchBuilder::Handle.
58
59       In Pg time and timestamp data types may be "with time zone" or "without
60       time zone".  So if Field argument is timestamp "with time zone" then
61       From argument is not required and is useless. Otherwise From argument
62       identifies time zone of the Field argument that is "without time zone".
63
64       For consistency with other DBs use timestamp columns without time zones
65       and provide From argument.
66

SEE ALSO
68       DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
69
70
71
72perl v5.30.1                      2020-01-29DBIx::SearchBuilder::Handle::Pg(3)



        

    


            
        

        

            Impressum