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   BuildDSN
19       Extend "BuildDNS" in DBIx::SearchBuilder::Handle to force
20       "client_encoding" to be UTF-8, so that character strings can be safely
21       passed to, and retrieved from, the database.  See "Encoding" in
22       DBD::Pg.
23
24   Insert
25       Takes a table name as the first argument and assumes that the rest of
26       the arguments are an array of key-value pairs to be inserted.
27
28       In case of insert failure, returns a Class::ReturnValue object
29       preloaded with error info.
30
31   InsertQueryString
32       Postgres sepcific overriding method for "InsertQueryString" in
33       DBIx::SearchBuilder::Handle.
34
35   IdSequenceName TABLE
36       Takes a TABLE name and returns the name of the  sequence of the primary
37       key for that table.
38
39   BinarySafeBLOBs
40       Return undef, as no current version of postgres supports binary-safe
41       blobs
42
43   ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
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       Takes a field, operator and value. performs the magic necessary to make
49       your database treat this clause as case insensitive.
50
51       Returns a FIELD OPERATOR VALUE triple.
52
53   DistinctQuery STATEMENTREF
54       takes an incomplete SQL SELECT statement and massages it to return a
55       DISTINCT result set.
56
57   SimpleDateTimeFunctions
58       Returns hash reference with specific date time functions of this
59       database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
60
61   ConvertTimezoneFunction
62       Custom implementation of "ConvertTimezoneFunction" in
63       DBIx::SearchBuilder::Handle.
64
65       In Pg time and timestamp data types may be "with time zone" or "without
66       time zone".  So if Field argument is timestamp "with time zone" then
67       From argument is not required and is useless. Otherwise From argument
68       identifies time zone of the Field argument that is "without time zone".
69
70       For consistency with other DBs use timestamp columns without time zones
71       and provide From argument.
72

SEE ALSO

74       DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
75
76
77
78perl v5.34.0                      2021-10-07DBIx::SearchBuilder::Handle::Pg(3)
Impressum