Gecko [ finalhopeacademy.com ]

/ usr / share / doc / postgresql-9.2.24 / html / [ HOME SHELL ]

Name	Size	Permission
LEGALNOTICE.html	2.62 KB	-rw-r--r--
acronyms.html	15.9 KB	-rw-r--r--
admin.html	12.27 KB	-rw-r--r--
adminpack.html	7.7 KB	-rw-r--r--
app-clusterdb.html	10.35 KB	-rw-r--r--
app-createdb.html	12.55 KB	-rw-r--r--
app-createlang.html	9.67 KB	-rw-r--r--
app-createuser.html	15.27 KB	-rw-r--r--
app-dropdb.html	9.42 KB	-rw-r--r--
app-droplang.html	9.41 KB	-rw-r--r--
app-dropuser.html	9.37 KB	-rw-r--r--
app-ecpg.html	8.51 KB	-rw-r--r--
app-initdb.html	15.04 KB	-rw-r--r--
app-pg-ctl.html	21.93 KB	-rw-r--r--
app-pg-dumpall.html	20.22 KB	-rw-r--r--
app-pgbasebackup.html	19.37 KB	-rw-r--r--
app-pgconfig.html	10.83 KB	-rw-r--r--
app-pgcontroldata.html	3.89 KB	-rw-r--r--
app-pgdump.html	42.93 KB	-rw-r--r--
app-pgreceivexlog.html	10.8 KB	-rw-r--r--
app-pgresetxlog.html	11.29 KB	-rw-r--r--
app-pgrestore.html	29.56 KB	-rw-r--r--
app-postgres.html	31.08 KB	-rw-r--r--
app-postmaster.html	2.93 KB	-rw-r--r--
app-psql.html	135.62 KB	-rw-r--r--
app-reindexdb.html	11.02 KB	-rw-r--r--
app-vacuumdb.html	12.32 KB	-rw-r--r--
appendixes.html	25.71 KB	-rw-r--r--
applevel-consistency.html	10.07 KB	-rw-r--r--
archive-recovery-settings.html	7.17 KB	-rw-r--r--
arrays.html	27.42 KB	-rw-r--r--
auth-delay.html	3.69 KB	-rw-r--r--
auth-methods.html	35.35 KB	-rw-r--r--
auth-pg-hba-conf.html	29.06 KB	-rw-r--r--
auth-username-maps.html	8.4 KB	-rw-r--r--
auto-explain.html	9.66 KB	-rw-r--r--
backup-dump.html	15.55 KB	-rw-r--r--
backup-file.html	7.81 KB	-rw-r--r--
backup.html	4.38 KB	-rw-r--r--
biblio.html	11.28 KB	-rw-r--r--
bki-commands.html	9.42 KB	-rw-r--r--
bki-example.html	2.98 KB	-rw-r--r--
bki-format.html	3.38 KB	-rw-r--r--
bki-structure.html	4.22 KB	-rw-r--r--
bki.html	4.23 KB	-rw-r--r--
bookindex.html	237.47 KB	-rw-r--r--
btree-gin.html	4.49 KB	-rw-r--r--
btree-gist.html	6.72 KB	-rw-r--r--
bug-reporting.html	18.21 KB	-rw-r--r--
catalog-pg-aggregate.html	5.37 KB	-rw-r--r--
catalog-pg-am.html	10.3 KB	-rw-r--r--
catalog-pg-amop.html	7.42 KB	-rw-r--r--
catalog-pg-amproc.html	4.77 KB	-rw-r--r--
catalog-pg-attrdef.html	4.26 KB	-rw-r--r--
catalog-pg-attribute.html	10.05 KB	-rw-r--r--
catalog-pg-auth-members.html	4.16 KB	-rw-r--r--
catalog-pg-authid.html	6.66 KB	-rw-r--r--
catalog-pg-cast.html	6.79 KB	-rw-r--r--
catalog-pg-class.html	12.36 KB	-rw-r--r--
catalog-pg-collation.html	5.76 KB	-rw-r--r--
catalog-pg-constraint.html	11.31 KB	-rw-r--r--
catalog-pg-conversion.html	4.33 KB	-rw-r--r--
catalog-pg-database.html	6.86 KB	-rw-r--r--
catalog-pg-db-role-setting.htm...	3.97 KB	-rw-r--r--
catalog-pg-default-acl.html	5.14 KB	-rw-r--r--
catalog-pg-depend.html	8.43 KB	-rw-r--r--
catalog-pg-description.html	4.37 KB	-rw-r--r--
catalog-pg-enum.html	4.61 KB	-rw-r--r--
catalog-pg-extension.html	5.16 KB	-rw-r--r--
catalog-pg-foreign-data-wrappe...	4.83 KB	-rw-r--r--
catalog-pg-foreign-server.html	4.58 KB	-rw-r--r--
catalog-pg-foreign-table.html	3.94 KB	-rw-r--r--
catalog-pg-index.html	8.66 KB	-rw-r--r--
catalog-pg-inherits.html	3.8 KB	-rw-r--r--
catalog-pg-language.html	5.81 KB	-rw-r--r--
catalog-pg-largeobject-metadat...	3.54 KB	-rw-r--r--
catalog-pg-largeobject.html	5.03 KB	-rw-r--r--
catalog-pg-namespace.html	3.66 KB	-rw-r--r--
catalog-pg-opclass.html	5.73 KB	-rw-r--r--
catalog-pg-operator.html	6.49 KB	-rw-r--r--
catalog-pg-opfamily.html	4.7 KB	-rw-r--r--
catalog-pg-pltemplate.html	5.24 KB	-rw-r--r--
catalog-pg-proc.html	13.09 KB	-rw-r--r--
catalog-pg-range.html	5.06 KB	-rw-r--r--
catalog-pg-rewrite.html	5.26 KB	-rw-r--r--
catalog-pg-seclabel.html	4.41 KB	-rw-r--r--
catalog-pg-shdepend.html	6.88 KB	-rw-r--r--
catalog-pg-shdescription.html	4.15 KB	-rw-r--r--
catalog-pg-shseclabel.html	4.3 KB	-rw-r--r--
catalog-pg-statistic.html	9.31 KB	-rw-r--r--
catalog-pg-tablespace.html	4.06 KB	-rw-r--r--
catalog-pg-trigger.html	8.09 KB	-rw-r--r--
catalog-pg-ts-config-map.html	4.09 KB	-rw-r--r--
catalog-pg-ts-config.html	4.38 KB	-rw-r--r--
catalog-pg-ts-dict.html	4.61 KB	-rw-r--r--
catalog-pg-ts-parser.html	4.96 KB	-rw-r--r--
catalog-pg-ts-template.html	4.16 KB	-rw-r--r--
catalog-pg-type.html	19.44 KB	-rw-r--r--
catalog-pg-user-mapping.html	3.76 KB	-rw-r--r--
catalogs-overview.html	10.19 KB	-rw-r--r--
catalogs.html	10.14 KB	-rw-r--r--
charset.html	4.06 KB	-rw-r--r--
chkpass.html	4.29 KB	-rw-r--r--
citext.html	10.89 KB	-rw-r--r--
client-authentication-problems...	4.13 KB	-rw-r--r--
client-authentication.html	5.78 KB	-rw-r--r--
client-interfaces.html	13.4 KB	-rw-r--r--
collation.html	13.89 KB	-rw-r--r--
config-setting.html	10.88 KB	-rw-r--r--
connect-estab.html	4.21 KB	-rw-r--r--
continuous-archiving.html	48.66 KB	-rw-r--r--
contrib-dblink-build-sql-delet...	5.32 KB	-rw-r--r--
contrib-dblink-build-sql-inser...	5.91 KB	-rw-r--r--
contrib-dblink-build-sql-updat...	6.13 KB	-rw-r--r--
contrib-dblink-cancel-query.ht...	3.73 KB	-rw-r--r--
contrib-dblink-close.html	4.54 KB	-rw-r--r--
contrib-dblink-connect-u.html	4.38 KB	-rw-r--r--
contrib-dblink-connect.html	7.15 KB	-rw-r--r--
contrib-dblink-disconnect.html	3.63 KB	-rw-r--r--
contrib-dblink-error-message.h...	3.43 KB	-rw-r--r--
contrib-dblink-exec.html	5.34 KB	-rw-r--r--
contrib-dblink-fetch.html	5.84 KB	-rw-r--r--
contrib-dblink-function.html	8.43 KB	-rw-r--r--
contrib-dblink-get-connections...	3.13 KB	-rw-r--r--
contrib-dblink-get-notify.html	4.07 KB	-rw-r--r--
contrib-dblink-get-pkey.html	4.39 KB	-rw-r--r--
contrib-dblink-get-result.html	6.8 KB	-rw-r--r--
contrib-dblink-is-busy.html	3.41 KB	-rw-r--r--
contrib-dblink-open.html	5.34 KB	-rw-r--r--
contrib-dblink-send-query.html	4.07 KB	-rw-r--r--
contrib-prog-client.html	3.35 KB	-rw-r--r--
contrib-prog-server.html	3.75 KB	-rw-r--r--
contrib-prog.html	3.24 KB	-rw-r--r--
contrib-spi.html	10.97 KB	-rw-r--r--
contrib.html	8.7 KB	-rw-r--r--
creating-cluster.html	12.17 KB	-rw-r--r--
cube.html	15.57 KB	-rw-r--r--
database-roles.html	5.95 KB	-rw-r--r--
datatype-binary.html	12.59 KB	-rw-r--r--
datatype-bit.html	4.98 KB	-rw-r--r--
datatype-boolean.html	5.14 KB	-rw-r--r--
datatype-character.html	11.61 KB	-rw-r--r--
datatype-datetime.html	49.57 KB	-rw-r--r--
datatype-enum.html	6.28 KB	-rw-r--r--
datatype-geometric.html	12.21 KB	-rw-r--r--
datatype-json.html	3.36 KB	-rw-r--r--
datatype-money.html	5.35 KB	-rw-r--r--
datatype-net-types.html	10.18 KB	-rw-r--r--
datatype-numeric.html	21.83 KB	-rw-r--r--
datatype-oid.html	9.46 KB	-rw-r--r--
datatype-pseudo.html	7.11 KB	-rw-r--r--
datatype-textsearch.html	9.8 KB	-rw-r--r--
datatype-uuid.html	4.45 KB	-rw-r--r--
datatype-xml.html	11.07 KB	-rw-r--r--
datatype.html	16.22 KB	-rw-r--r--
datetime-appendix.html	3.44 KB	-rw-r--r--
datetime-config-files.html	8.77 KB	-rw-r--r--
datetime-input-rules.html	6.6 KB	-rw-r--r--
datetime-keywords.html	4.98 KB	-rw-r--r--
datetime-units-history.html	7.46 KB	-rw-r--r--
dblink.html	5.2 KB	-rw-r--r--
ddl-alter.html	10.25 KB	-rw-r--r--
ddl-basics.html	7.63 KB	-rw-r--r--
ddl-constraints.html	22.26 KB	-rw-r--r--
ddl-default.html	4.43 KB	-rw-r--r--
ddl-depend.html	6.35 KB	-rw-r--r--
ddl-foreign-data.html	4.38 KB	-rw-r--r--
ddl-inherit.html	14.95 KB	-rw-r--r--
ddl-others.html	3.01 KB	-rw-r--r--
ddl-partitioning.html	27.11 KB	-rw-r--r--
ddl-priv.html	5.92 KB	-rw-r--r--
ddl-schemas.html	17.62 KB	-rw-r--r--
ddl-system-columns.html	7.86 KB	-rw-r--r--
ddl.html	6.23 KB	-rw-r--r--
dict-int.html	4.68 KB	-rw-r--r--
dict-xsyn.html	6.33 KB	-rw-r--r--
different-replication-solution...	14.45 KB	-rw-r--r--
disk-full.html	3.43 KB	-rw-r--r--
disk-usage.html	5.53 KB	-rw-r--r--
diskusage.html	2.61 KB	-rw-r--r--
dml-delete.html	3.48 KB	-rw-r--r--
dml-insert.html	5.67 KB	-rw-r--r--
dml-returning.html	4.98 KB	-rw-r--r--
dml-update.html	5.43 KB	-rw-r--r--
dml.html	2.88 KB	-rw-r--r--
docguide-authoring.html	6.6 KB	-rw-r--r--
docguide-build.html	14.92 KB	-rw-r--r--
docguide-docbook.html	3.76 KB	-rw-r--r--
docguide-style.html	7.25 KB	-rw-r--r--
docguide-toolsets.html	20.2 KB	-rw-r--r--
docguide.html	3.54 KB	-rw-r--r--
dummy-seclabel.html	4.26 KB	-rw-r--r--
dynamic-trace.html	26.6 KB	-rw-r--r--
earthdistance.html	8.6 KB	-rw-r--r--
ecpg-commands.html	9.3 KB	-rw-r--r--
ecpg-concept.html	4.86 KB	-rw-r--r--
ecpg-connect.html	10.57 KB	-rw-r--r--
ecpg-cpp.html	9.4 KB	-rw-r--r--
ecpg-descriptors.html	34.09 KB	-rw-r--r--
ecpg-develop.html	7.78 KB	-rw-r--r--
ecpg-dynamic.html	6.36 KB	-rw-r--r--
ecpg-errors.html	25.13 KB	-rw-r--r--
ecpg-informix-compat.html	51.52 KB	-rw-r--r--
ecpg-library.html	5.66 KB	-rw-r--r--
ecpg-lo.html	5.4 KB	-rw-r--r--
ecpg-pgtypes.html	53.18 KB	-rw-r--r--
ecpg-preproc.html	8.77 KB	-rw-r--r--
ecpg-process.html	5.26 KB	-rw-r--r--
ecpg-sql-allocate-descriptor.h...	3.89 KB	-rw-r--r--
ecpg-sql-commands.html	4.59 KB	-rw-r--r--
ecpg-sql-connect.html	9.16 KB	-rw-r--r--
ecpg-sql-deallocate-descriptor...	3.68 KB	-rw-r--r--
ecpg-sql-declare.html	5.27 KB	-rw-r--r--
ecpg-sql-describe.html	4.49 KB	-rw-r--r--
ecpg-sql-disconnect.html	4.62 KB	-rw-r--r--
ecpg-sql-execute-immediate.htm...	3.79 KB	-rw-r--r--
ecpg-sql-get-descriptor.html	7.53 KB	-rw-r--r--
ecpg-sql-open.html	4.53 KB	-rw-r--r--
ecpg-sql-prepare.html	4.08 KB	-rw-r--r--
ecpg-sql-set-autocommit.html	3.25 KB	-rw-r--r--
ecpg-sql-set-connection.html	3.84 KB	-rw-r--r--
ecpg-sql-set-descriptor.html	5.38 KB	-rw-r--r--
ecpg-sql-type.html	4.91 KB	-rw-r--r--
ecpg-sql-var.html	3.46 KB	-rw-r--r--
ecpg-sql-whenever.html	4.58 KB	-rw-r--r--
ecpg-variables.html	39.34 KB	-rw-r--r--
ecpg.html	10.1 KB	-rw-r--r--
encryption-options.html	7.32 KB	-rw-r--r--
errcodes-appendix.html	36.1 KB	-rw-r--r--
error-message-reporting.html	13.79 KB	-rw-r--r--
error-style-guide.html	16.38 KB	-rw-r--r--
event-log-registration.html	4.09 KB	-rw-r--r--
executor.html	6.46 KB	-rw-r--r--
explicit-joins.html	10.76 KB	-rw-r--r--
explicit-locking.html	24.49 KB	-rw-r--r--
extend-extensions.html	31.67 KB	-rw-r--r--
extend-how.html	4.45 KB	-rw-r--r--
extend-pgxs.html	11.49 KB	-rw-r--r--
extend-type-system.html	9.87 KB	-rw-r--r--
extend.html	9.75 KB	-rw-r--r--
external-admin-tools.html	2.66 KB	-rw-r--r--
external-extensions.html	3.19 KB	-rw-r--r--
external-interfaces.html	5.38 KB	-rw-r--r--
external-pl.html	4.56 KB	-rw-r--r--
external-projects.html	2.93 KB	-rw-r--r--
fdw-callbacks.html	12.6 KB	-rw-r--r--
fdw-functions.html	4.39 KB	-rw-r--r--
fdw-helpers.html	5.85 KB	-rw-r--r--
fdw-planning.html	9.61 KB	-rw-r--r--
fdwhandler.html	3.9 KB	-rw-r--r--
features-sql-standard.html	38.19 KB	-rw-r--r--
features.html	7.39 KB	-rw-r--r--
file-fdw.html	7.53 KB	-rw-r--r--
functions-admin.html	49.21 KB	-rw-r--r--
functions-aggregate.html	21.3 KB	-rw-r--r--
functions-array.html	13.2 KB	-rw-r--r--
functions-binarystring.html	12.29 KB	-rw-r--r--
functions-bitstring.html	6.63 KB	-rw-r--r--
functions-comparison.html	10.39 KB	-rw-r--r--
functions-comparisons.html	13.21 KB	-rw-r--r--
functions-conditional.html	10.75 KB	-rw-r--r--
functions-datetime.html	47.17 KB	-rw-r--r--
functions-enum.html	5.36 KB	-rw-r--r--
functions-formatting.html	34.57 KB	-rw-r--r--
functions-geometry.html	19.87 KB	-rw-r--r--
functions-info.html	57.28 KB	-rw-r--r--
functions-json.html	3.72 KB	-rw-r--r--
functions-logical.html	4.56 KB	-rw-r--r--
functions-matching.html	73.95 KB	-rw-r--r--
functions-math.html	19.92 KB	-rw-r--r--
functions-net.html	13.19 KB	-rw-r--r--
functions-range.html	10.6 KB	-rw-r--r--
functions-sequence.html	12.62 KB	-rw-r--r--
functions-srf.html	8.63 KB	-rw-r--r--
functions-string.html	57.67 KB	-rw-r--r--
functions-subquery.html	16 KB	-rw-r--r--
functions-textsearch.html	20.01 KB	-rw-r--r--
functions-trigger.html	4.44 KB	-rw-r--r--
functions-window.html	11.8 KB	-rw-r--r--
functions-xml.html	31.42 KB	-rw-r--r--
functions.html	9.71 KB	-rw-r--r--
fuzzystrmatch.html	7.87 KB	-rw-r--r--
geqo-biblio.html	3.38 KB	-rw-r--r--
geqo-intro.html	4.31 KB	-rw-r--r--
geqo-intro2.html	5.5 KB	-rw-r--r--
geqo-pg-intro.html	8.58 KB	-rw-r--r--
geqo.html	3.53 KB	-rw-r--r--
gin-examples.html	3.24 KB	-rw-r--r--
gin-extensibility.html	14.06 KB	-rw-r--r--
gin-implementation.html	6.41 KB	-rw-r--r--
gin-intro.html	4.55 KB	-rw-r--r--
gin-limit.html	2.75 KB	-rw-r--r--
gin-tips.html	5.58 KB	-rw-r--r--
gin.html	2.86 KB	-rw-r--r--
gist-examples.html	3.66 KB	-rw-r--r--
gist-extensibility.html	23.78 KB	-rw-r--r--
gist-implementation.html	4 KB	-rw-r--r--
gist-intro.html	3.53 KB	-rw-r--r--
gist.html	2.62 KB	-rw-r--r--
git.html	4.46 KB	-rw-r--r--
high-availability.html	7.52 KB	-rw-r--r--
history.html	11.64 KB	-rw-r--r--
hot-standby.html	35.2 KB	-rw-r--r--
hstore.html	22.1 KB	-rw-r--r--
index-catalog.html	7.81 KB	-rw-r--r--
index-cost-estimation.html	9.76 KB	-rw-r--r--
index-functions.html	18.67 KB	-rw-r--r--
index-locking.html	7.86 KB	-rw-r--r--
index-scanning.html	10.46 KB	-rw-r--r--
index-unique-checks.html	8.98 KB	-rw-r--r--
index.html	7.88 KB	-rw-r--r--
indexam.html	5.12 KB	-rw-r--r--
indexes-bitmap-scans.html	6.43 KB	-rw-r--r--
indexes-collations.html	3.55 KB	-rw-r--r--
indexes-examine.html	6.99 KB	-rw-r--r--
indexes-expressional.html	4.7 KB	-rw-r--r--
indexes-intro.html	6.17 KB	-rw-r--r--
indexes-multicolumn.html	6.15 KB	-rw-r--r--
indexes-opclass.html	7.16 KB	-rw-r--r--
indexes-ordering.html	6.33 KB	-rw-r--r--
indexes-partial.html	11.54 KB	-rw-r--r--
indexes-types.html	9.99 KB	-rw-r--r--
indexes-unique.html	3.91 KB	-rw-r--r--
indexes.html	3.53 KB	-rw-r--r--
information-schema.html	10.92 KB	-rw-r--r--
infoschema-administrable-role-...	3.66 KB	-rw-r--r--
infoschema-applicable-roles.ht...	3.88 KB	-rw-r--r--
infoschema-attributes.html	12.51 KB	-rw-r--r--
infoschema-character-sets.html	6.88 KB	-rw-r--r--
infoschema-check-constraint-ro...	4.25 KB	-rw-r--r--
infoschema-check-constraints.h...	3.79 KB	-rw-r--r--
infoschema-collation-character...	4.32 KB	-rw-r--r--
infoschema-collations.html	3.79 KB	-rw-r--r--
infoschema-column-domain-usage...	4.22 KB	-rw-r--r--
infoschema-column-options.html	4.01 KB	-rw-r--r--
infoschema-column-privileges.h...	4.91 KB	-rw-r--r--
infoschema-column-udt-usage.ht...	4.48 KB	-rw-r--r--
infoschema-columns.html	17.21 KB	-rw-r--r--
infoschema-constraint-column-u...	4.76 KB	-rw-r--r--
infoschema-constraint-table-us...	4.66 KB	-rw-r--r--
infoschema-data-type-privilege...	4.97 KB	-rw-r--r--
infoschema-datatypes.html	4.13 KB	-rw-r--r--
infoschema-domain-constraints....	4.55 KB	-rw-r--r--
infoschema-domain-udt-usage.ht...	4.07 KB	-rw-r--r--
infoschema-domains.html	11.1 KB	-rw-r--r--
infoschema-element-types.html	11.11 KB	-rw-r--r--
infoschema-enabled-roles.html	3.69 KB	-rw-r--r--
infoschema-foreign-data-wrappe...	3.82 KB	-rw-r--r--
infoschema-foreign-data-wrappe...	4.13 KB	-rw-r--r--
infoschema-foreign-server-opti...	3.76 KB	-rw-r--r--
infoschema-foreign-servers.htm...	4.46 KB	-rw-r--r--
infoschema-foreign-table-optio...	3.88 KB	-rw-r--r--
infoschema-foreign-tables.html	3.98 KB	-rw-r--r--
infoschema-information-schema-...	3.28 KB	-rw-r--r--
infoschema-key-column-usage.ht...	5.06 KB	-rw-r--r--
infoschema-parameters.html	10.55 KB	-rw-r--r--
infoschema-referential-constra...	5.53 KB	-rw-r--r--
infoschema-role-column-grants....	4.9 KB	-rw-r--r--
infoschema-role-routine-grants...	5.23 KB	-rw-r--r--
infoschema-role-table-grants.h...	5.3 KB	-rw-r--r--
infoschema-role-udt-grants.htm...	4.67 KB	-rw-r--r--
infoschema-role-usage-grants.h...	4.89 KB	-rw-r--r--
infoschema-routine-privileges....	4.91 KB	-rw-r--r--
infoschema-routines.html	22.51 KB	-rw-r--r--
infoschema-schema.html	3.11 KB	-rw-r--r--
infoschema-schemata.html	4.15 KB	-rw-r--r--
infoschema-sequences.html	5.97 KB	-rw-r--r--
infoschema-sql-features.html	4.6 KB	-rw-r--r--
infoschema-sql-implementation-...	4.4 KB	-rw-r--r--
infoschema-sql-languages.html	4.97 KB	-rw-r--r--
infoschema-sql-packages.html	4.08 KB	-rw-r--r--
infoschema-sql-parts.html	3.98 KB	-rw-r--r--
infoschema-sql-sizing-profiles...	4.08 KB	-rw-r--r--
infoschema-sql-sizing.html	4 KB	-rw-r--r--
infoschema-table-constraints.h...	4.8 KB	-rw-r--r--
infoschema-table-privileges.ht...	4.98 KB	-rw-r--r--
infoschema-tables.html	5.82 KB	-rw-r--r--
infoschema-triggered-update-co...	4.45 KB	-rw-r--r--
infoschema-triggers.html	9.23 KB	-rw-r--r--
infoschema-udt-privileges.html	4.4 KB	-rw-r--r--
infoschema-usage-privileges.ht...	5.38 KB	-rw-r--r--
infoschema-user-defined-types....	9.52 KB	-rw-r--r--
infoschema-user-mapping-option...	4.34 KB	-rw-r--r--
infoschema-user-mappings.html	3.74 KB	-rw-r--r--
infoschema-view-column-usage.h...	4.62 KB	-rw-r--r--
infoschema-view-routine-usage....	4.27 KB	-rw-r--r--
infoschema-view-table-usage.ht...	4.29 KB	-rw-r--r--
infoschema-views.html	5.4 KB	-rw-r--r--
install-getsource.html	3.49 KB	-rw-r--r--
install-post.html	7.89 KB	-rw-r--r--
install-procedure.html	45.44 KB	-rw-r--r--
install-requirements.html	14.14 KB	-rw-r--r--
install-short.html	2.8 KB	-rw-r--r--
install-windows-full.html	18.82 KB	-rw-r--r--
install-windows-libpq.html	6.14 KB	-rw-r--r--
install-windows.html	6.46 KB	-rw-r--r--
installation-platform-notes.ht...	38.46 KB	-rw-r--r--
installation.html	4.06 KB	-rw-r--r--
intagg.html	6.11 KB	-rw-r--r--
intarray.html	13.43 KB	-rw-r--r--
internals.html	15.27 KB	-rw-r--r--
intro-whatis.html	3.92 KB	-rw-r--r--
isn.html	13.04 KB	-rw-r--r--
kernel-resources.html	36.94 KB	-rw-r--r--
largeobjects.html	4.57 KB	-rw-r--r--
libpq-async.html	20.53 KB	-rw-r--r--
libpq-build.html	6.22 KB	-rw-r--r--
libpq-cancel.html	6.62 KB	-rw-r--r--
libpq-connect.html	50.05 KB	-rw-r--r--
libpq-control.html	6.13 KB	-rw-r--r--
libpq-copy.html	21.92 KB	-rw-r--r--
libpq-envars.html	9.59 KB	-rw-r--r--
libpq-events.html	22.55 KB	-rw-r--r--
libpq-example.html	15.65 KB	-rw-r--r--
libpq-exec.html	63.36 KB	-rw-r--r--
libpq-fastpath.html	5.98 KB	-rw-r--r--
libpq-ldap.html	5.38 KB	-rw-r--r--
libpq-misc.html	13.49 KB	-rw-r--r--
libpq-notice-processing.html	6.14 KB	-rw-r--r--
libpq-notify.html	6.56 KB	-rw-r--r--
libpq-pgpass.html	4.75 KB	-rw-r--r--
libpq-pgservice.html	3.81 KB	-rw-r--r--
libpq-single-row-mode.html	6.2 KB	-rw-r--r--
libpq-ssl.html	19.5 KB	-rw-r--r--
libpq-status.html	17.28 KB	-rw-r--r--
libpq-threading.html	5.41 KB	-rw-r--r--
libpq.html	7.73 KB	-rw-r--r--
lo-examplesect.html	8.49 KB	-rw-r--r--
lo-funcs.html	4.53 KB	-rw-r--r--
lo-implementation.html	3.27 KB	-rw-r--r--
lo-interfaces.html	14.8 KB	-rw-r--r--
lo-intro.html	3.13 KB	-rw-r--r--
lo.html	6.47 KB	-rw-r--r--
locale.html	13.37 KB	-rw-r--r--
locking-indexes.html	4.25 KB	-rw-r--r--
log-shipping-alternative.html	10.8 KB	-rw-r--r--
logfile-maintenance.html	6.98 KB	-rw-r--r--
ltree.html	26.66 KB	-rw-r--r--
maintenance.html	5.41 KB	-rw-r--r--
manage-ag-config.html	3.66 KB	-rw-r--r--
manage-ag-createdb.html	6.16 KB	-rw-r--r--
manage-ag-dropdb.html	3.52 KB	-rw-r--r--
manage-ag-overview.html	5.02 KB	-rw-r--r--
manage-ag-tablespaces.html	9.03 KB	-rw-r--r--
manage-ag-templatedbs.html	7.97 KB	-rw-r--r--
managing-databases.html	3.2 KB	-rw-r--r--
monitoring-locks.html	3.59 KB	-rw-r--r--
monitoring-ps.html	6.62 KB	-rw-r--r--
monitoring-stats.html	56.7 KB	-rw-r--r--
monitoring.html	4.35 KB	-rw-r--r--
multibyte.html	31.22 KB	-rw-r--r--
mvcc-caveats.html	3.98 KB	-rw-r--r--
mvcc-intro.html	4.45 KB	-rw-r--r--
mvcc.html	4.2 KB	-rw-r--r--
nls-programmer.html	9.84 KB	-rw-r--r--
nls-translator.html	14.18 KB	-rw-r--r--
nls.html	3.06 KB	-rw-r--r--
non-durability.html	4.38 KB	-rw-r--r--
notation.html	4.31 KB	-rw-r--r--
oid2name.html	11.68 KB	-rw-r--r--
overview.html	4 KB	-rw-r--r--
pageinspect.html	7.93 KB	-rw-r--r--
parser-stage.html	7.93 KB	-rw-r--r--
passwordcheck.html	4.68 KB	-rw-r--r--
performance-tips.html	4.4 KB	-rw-r--r--
perm-functions.html	3.26 KB	-rw-r--r--
pgarchivecleanup.html	8.79 KB	-rw-r--r--
pgbench.html	30.11 KB	-rw-r--r--
pgbuffercache.html	7.53 KB	-rw-r--r--
pgcrypto.html	37.89 KB	-rw-r--r--
pgfreespacemap.html	5.11 KB	-rw-r--r--
pgrowlocks.html	5.94 KB	-rw-r--r--
pgstandby.html	14.85 KB	-rw-r--r--
pgstatstatements.html	15.69 KB	-rw-r--r--
pgstattuple.html	9.23 KB	-rw-r--r--
pgtestfsync.html	5.13 KB	-rw-r--r--
pgtesttiming.html	12.18 KB	-rw-r--r--
pgtrgm.html	12.04 KB	-rw-r--r--
pgupgrade.html	24.16 KB	-rw-r--r--
planner-optimizer.html	9.18 KB	-rw-r--r--
planner-stats-details.html	3.2 KB	-rw-r--r--
planner-stats-security.html	5.43 KB	-rw-r--r--
planner-stats.html	8.85 KB	-rw-r--r--
plhandler.html	13.43 KB	-rw-r--r--
plperl-builtins.html	17.85 KB	-rw-r--r--
plperl-data.html	2.81 KB	-rw-r--r--
plperl-funcs.html	13.06 KB	-rw-r--r--
plperl-global.html	4.95 KB	-rw-r--r--
plperl-triggers.html	6.29 KB	-rw-r--r--
plperl-trusted.html	6.55 KB	-rw-r--r--
plperl-under-the-hood.html	8.78 KB	-rw-r--r--
plperl.html	4.81 KB	-rw-r--r--
plpgsql-control-structures.htm...	45.1 KB	-rw-r--r--
plpgsql-cursors.html	24.99 KB	-rw-r--r--
plpgsql-declarations.html	21.24 KB	-rw-r--r--
plpgsql-development-tips.html	9.29 KB	-rw-r--r--
plpgsql-errors-and-messages.ht...	9.86 KB	-rw-r--r--
plpgsql-expressions.html	4.55 KB	-rw-r--r--
plpgsql-implementation.html	17.62 KB	-rw-r--r--
plpgsql-overview.html	8.82 KB	-rw-r--r--
plpgsql-porting.html	26.46 KB	-rw-r--r--
plpgsql-statements.html	31.47 KB	-rw-r--r--
plpgsql-structure.html	8.13 KB	-rw-r--r--
plpgsql-trigger.html	21.8 KB	-rw-r--r--
plpgsql.html	6.8 KB	-rw-r--r--
plpython-data.html	14.3 KB	-rw-r--r--
plpython-database.html	15.05 KB	-rw-r--r--
plpython-do.html	2.71 KB	-rw-r--r--
plpython-envar.html	3.79 KB	-rw-r--r--
plpython-funcs.html	5.35 KB	-rw-r--r--
plpython-python23.html	7.04 KB	-rw-r--r--
plpython-sharing.html	2.96 KB	-rw-r--r--
plpython-subtransaction.html	7.7 KB	-rw-r--r--
plpython-trigger.html	4.95 KB	-rw-r--r--
plpython-util.html	4.98 KB	-rw-r--r--
plpython.html	5.92 KB	-rw-r--r--
pltcl-data.html	2.84 KB	-rw-r--r--
pltcl-dbaccess.html	13.58 KB	-rw-r--r--
pltcl-functions.html	6.03 KB	-rw-r--r--
pltcl-global.html	4.95 KB	-rw-r--r--
pltcl-overview.html	5.16 KB	-rw-r--r--
pltcl-procnames.html	3.15 KB	-rw-r--r--
pltcl-trigger.html	9.23 KB	-rw-r--r--
pltcl-unknown.html	4.96 KB	-rw-r--r--
pltcl.html	3.32 KB	-rw-r--r--
populate.html	16.71 KB	-rw-r--r--
postgres-user.html	3.24 KB	-rw-r--r--
preface.html	4.95 KB	-rw-r--r--
preventing-server-spoofing.htm...	4.5 KB	-rw-r--r--
protocol-changes.html	6.49 KB	-rw-r--r--
protocol-error-fields.html	5.99 KB	-rw-r--r--
protocol-flow.html	45.12 KB	-rw-r--r--
protocol-message-formats.html	39.89 KB	-rw-r--r--
protocol-message-types.html	4.82 KB	-rw-r--r--
protocol-overview.html	9.44 KB	-rw-r--r--
protocol-replication.html	14.32 KB	-rw-r--r--
protocol.html	5.52 KB	-rw-r--r--
queries-limit.html	5.21 KB	-rw-r--r--
queries-order.html	7.2 KB	-rw-r--r--
queries-overview.html	4.95 KB	-rw-r--r--
queries-select-lists.html	9.09 KB	-rw-r--r--
queries-table-expressions.html	38.94 KB	-rw-r--r--
queries-union.html	4.99 KB	-rw-r--r--
queries-values.html	4.81 KB	-rw-r--r--
queries-with.html	20.39 KB	-rw-r--r--
queries.html	4.31 KB	-rw-r--r--
query-path.html	5.34 KB	-rw-r--r--
querytree.html	10.88 KB	-rw-r--r--
rangetypes.html	22.2 KB	-rw-r--r--
recovery-config.html	3.47 KB	-rw-r--r--
recovery-target-settings.html	7.58 KB	-rw-r--r--
reference-client.html	5.96 KB	-rw-r--r--
reference-server.html	3.87 KB	-rw-r--r--
reference.html	22.62 KB	-rw-r--r--
regress-coverage.html	3.25 KB	-rw-r--r--
regress-evaluation.html	12.19 KB	-rw-r--r--
regress-run.html	13.39 KB	-rw-r--r--
regress-variant.html	7.01 KB	-rw-r--r--
regress.html	4.18 KB	-rw-r--r--
release-0-01.html	2.5 KB	-rw-r--r--
release-0-02.html	4.19 KB	-rw-r--r--
release-0-03.html	7.62 KB	-rw-r--r--
release-1-0.html	4.13 KB	-rw-r--r--
release-1-01.html	9.13 KB	-rw-r--r--
release-1-02.html	6.34 KB	-rw-r--r--
release-1-09.html	2.47 KB	-rw-r--r--
release-6-0.html	7.73 KB	-rw-r--r--
release-6-1-1.html	3.63 KB	-rw-r--r--
release-6-1.html	8.81 KB	-rw-r--r--
release-6-2-1.html	4.3 KB	-rw-r--r--
release-6-2.html	8.67 KB	-rw-r--r--
release-6-3-1.html	4.34 KB	-rw-r--r--
release-6-3-2.html	4.06 KB	-rw-r--r--
release-6-3.html	15.93 KB	-rw-r--r--
release-6-4-1.html	3.97 KB	-rw-r--r--
release-6-4-2.html	2.84 KB	-rw-r--r--
release-6-4.html	14.39 KB	-rw-r--r--
release-6-5-1.html	3.75 KB	-rw-r--r--
release-6-5-2.html	4.01 KB	-rw-r--r--
release-6-5-3.html	2.98 KB	-rw-r--r--
release-6-5.html	16.98 KB	-rw-r--r--
release-7-0-1.html	3.83 KB	-rw-r--r--
release-7-0-2.html	2.82 KB	-rw-r--r--
release-7-0-3.html	4.55 KB	-rw-r--r--
release-7-0.html	22.56 KB	-rw-r--r--
release-7-1-1.html	3.19 KB	-rw-r--r--
release-7-1-2.html	2.91 KB	-rw-r--r--
release-7-1-3.html	3.07 KB	-rw-r--r--
release-7-1.html	12.71 KB	-rw-r--r--
release-7-2-1.html	3.92 KB	-rw-r--r--
release-7-2-2.html	3.7 KB	-rw-r--r--
release-7-2-3.html	3.29 KB	-rw-r--r--
release-7-2-4.html	3.5 KB	-rw-r--r--
release-7-2-5.html	3.66 KB	-rw-r--r--
release-7-2-6.html	3.54 KB	-rw-r--r--
release-7-2-7.html	3.64 KB	-rw-r--r--
release-7-2-8.html	3.86 KB	-rw-r--r--
release-7-2.html	26.46 KB	-rw-r--r--
release-7-3-1.html	4.07 KB	-rw-r--r--
release-7-3-10.html	7.32 KB	-rw-r--r--
release-7-3-11.html	4.01 KB	-rw-r--r--
release-7-3-12.html	3.44 KB	-rw-r--r--
release-7-3-13.html	4.51 KB	-rw-r--r--
release-7-3-14.html	3.84 KB	-rw-r--r--
release-7-3-15.html	6.17 KB	-rw-r--r--
release-7-3-16.html	3.34 KB	-rw-r--r--
release-7-3-17.html	3.47 KB	-rw-r--r--
release-7-3-18.html	3.56 KB	-rw-r--r--
release-7-3-19.html	3.6 KB	-rw-r--r--
release-7-3-2.html	5.08 KB	-rw-r--r--
release-7-3-20.html	3.44 KB	-rw-r--r--
release-7-3-21.html	6.07 KB	-rw-r--r--
release-7-3-3.html	10.05 KB	-rw-r--r--
release-7-3-4.html	3.42 KB	-rw-r--r--
release-7-3-5.html	4.39 KB	-rw-r--r--
release-7-3-6.html	4.32 KB	-rw-r--r--
release-7-3-7.html	3.27 KB	-rw-r--r--
release-7-3-8.html	3.49 KB	-rw-r--r--
release-7-3-9.html	3.98 KB	-rw-r--r--
release-7-3.html	32.28 KB	-rw-r--r--
release-7-4-1.html	6.95 KB	-rw-r--r--
release-7-4-10.html	3.72 KB	-rw-r--r--
release-7-4-11.html	4.74 KB	-rw-r--r--
release-7-4-12.html	4.12 KB	-rw-r--r--
release-7-4-13.html	6.8 KB	-rw-r--r--
release-7-4-14.html	3.59 KB	-rw-r--r--
release-7-4-15.html	4.17 KB	-rw-r--r--
release-7-4-16.html	3.88 KB	-rw-r--r--
release-7-4-17.html	3.92 KB	-rw-r--r--
release-7-4-18.html	3.83 KB	-rw-r--r--
release-7-4-19.html	7.07 KB	-rw-r--r--
release-7-4-2.html	8.07 KB	-rw-r--r--
release-7-4-20.html	6.45 KB	-rw-r--r--
release-7-4-21.html	3.83 KB	-rw-r--r--
release-7-4-22.html	3.98 KB	-rw-r--r--
release-7-4-23.html	4.32 KB	-rw-r--r--
release-7-4-24.html	4.19 KB	-rw-r--r--
release-7-4-25.html	4.4 KB	-rw-r--r--
release-7-4-26.html	5.33 KB	-rw-r--r--
release-7-4-27.html	5.04 KB	-rw-r--r--
release-7-4-28.html	5.5 KB	-rw-r--r--
release-7-4-29.html	6.8 KB	-rw-r--r--
release-7-4-3.html	4.51 KB	-rw-r--r--
release-7-4-30.html	6.07 KB	-rw-r--r--
release-7-4-4.html	3.99 KB	-rw-r--r--
release-7-4-5.html	3.12 KB	-rw-r--r--
release-7-4-6.html	4.62 KB	-rw-r--r--
release-7-4-7.html	4.17 KB	-rw-r--r--
release-7-4-8.html	9.92 KB	-rw-r--r--
release-7-4-9.html	5 KB	-rw-r--r--
release-7-4.html	56.03 KB	-rw-r--r--
release-8-0-1.html	4.63 KB	-rw-r--r--
release-8-0-10.html	4.64 KB	-rw-r--r--
release-8-0-11.html	3.88 KB	-rw-r--r--
release-8-0-12.html	3.06 KB	-rw-r--r--
release-8-0-13.html	4.02 KB	-rw-r--r--
release-8-0-14.html	4.41 KB	-rw-r--r--
release-8-0-15.html	8.89 KB	-rw-r--r--
release-8-0-16.html	8.74 KB	-rw-r--r--
release-8-0-17.html	3.83 KB	-rw-r--r--
release-8-0-18.html	5.45 KB	-rw-r--r--
release-8-0-19.html	4.86 KB	-rw-r--r--
release-8-0-2.html	9.34 KB	-rw-r--r--
release-8-0-20.html	4.21 KB	-rw-r--r--
release-8-0-21.html	4.4 KB	-rw-r--r--
release-8-0-22.html	6.29 KB	-rw-r--r--
release-8-0-23.html	5.88 KB	-rw-r--r--
release-8-0-24.html	6.84 KB	-rw-r--r--
release-8-0-25.html	7.25 KB	-rw-r--r--
release-8-0-26.html	7.84 KB	-rw-r--r--
release-8-0-3.html	7.25 KB	-rw-r--r--
release-8-0-4.html	6.52 KB	-rw-r--r--
release-8-0-5.html	4.7 KB	-rw-r--r--
release-8-0-6.html	5.56 KB	-rw-r--r--
release-8-0-7.html	5.77 KB	-rw-r--r--
release-8-0-8.html	7.06 KB	-rw-r--r--
release-8-0-9.html	4.21 KB	-rw-r--r--
release-8-0.html	65.25 KB	-rw-r--r--
release-8-1-1.html	5.33 KB	-rw-r--r--
release-8-1-10.html	4.67 KB	-rw-r--r--
release-8-1-11.html	9.71 KB	-rw-r--r--
release-8-1-12.html	9.12 KB	-rw-r--r--
release-8-1-13.html	4.19 KB	-rw-r--r--
release-8-1-14.html	6.74 KB	-rw-r--r--
release-8-1-15.html	6.13 KB	-rw-r--r--
release-8-1-16.html	5.15 KB	-rw-r--r--
release-8-1-17.html	5.89 KB	-rw-r--r--
release-8-1-18.html	6.29 KB	-rw-r--r--
release-8-1-19.html	6.46 KB	-rw-r--r--
release-8-1-2.html	6.19 KB	-rw-r--r--
release-8-1-20.html	7.13 KB	-rw-r--r--
release-8-1-21.html	7.04 KB	-rw-r--r--
release-8-1-22.html	8.13 KB	-rw-r--r--
release-8-1-23.html	7.75 KB	-rw-r--r--
release-8-1-3.html	6.86 KB	-rw-r--r--
release-8-1-4.html	8.67 KB	-rw-r--r--
release-8-1-5.html	5.35 KB	-rw-r--r--
release-8-1-6.html	5.21 KB	-rw-r--r--
release-8-1-7.html	4.45 KB	-rw-r--r--
release-8-1-8.html	3.04 KB	-rw-r--r--
release-8-1-9.html	4.29 KB	-rw-r--r--
release-8-1.html	60.66 KB	-rw-r--r--
release-8-2-1.html	4.95 KB	-rw-r--r--
release-8-2-10.html	7.99 KB	-rw-r--r--
release-8-2-11.html	6.98 KB	-rw-r--r--
release-8-2-12.html	6.59 KB	-rw-r--r--
release-8-2-13.html	7.18 KB	-rw-r--r--
release-8-2-14.html	7.69 KB	-rw-r--r--
release-8-2-15.html	7.96 KB	-rw-r--r--
release-8-2-16.html	9.08 KB	-rw-r--r--
release-8-2-17.html	8.02 KB	-rw-r--r--
release-8-2-18.html	10.04 KB	-rw-r--r--
release-8-2-19.html	8.39 KB	-rw-r--r--
release-8-2-2.html	5.67 KB	-rw-r--r--
release-8-2-20.html	6.1 KB	-rw-r--r--
release-8-2-21.html	5.46 KB	-rw-r--r--
release-8-2-22.html	9.39 KB	-rw-r--r--
release-8-2-23.html	9.33 KB	-rw-r--r--
release-8-2-3.html	3.02 KB	-rw-r--r--
release-8-2-4.html	5.3 KB	-rw-r--r--
release-8-2-5.html	5.85 KB	-rw-r--r--
release-8-2-6.html	10.3 KB	-rw-r--r--
release-8-2-7.html	9.09 KB	-rw-r--r--
release-8-2-8.html	7.34 KB	-rw-r--r--
release-8-2-9.html	4.18 KB	-rw-r--r--
release-8-2.html	67.77 KB	-rw-r--r--
release-8-3-1.html	10.34 KB	-rw-r--r--
release-8-3-10.html	10.47 KB	-rw-r--r--
release-8-3-11.html	8.75 KB	-rw-r--r--
release-8-3-12.html	11.83 KB	-rw-r--r--
release-8-3-13.html	9.28 KB	-rw-r--r--
release-8-3-14.html	6.1 KB	-rw-r--r--
release-8-3-15.html	6.23 KB	-rw-r--r--
release-8-3-16.html	10.76 KB	-rw-r--r--
release-8-3-17.html	10.34 KB	-rw-r--r--
release-8-3-18.html	11 KB	-rw-r--r--
release-8-3-19.html	8.27 KB	-rw-r--r--
release-8-3-2.html	11.92 KB	-rw-r--r--
release-8-3-20.html	9.03 KB	-rw-r--r--
release-8-3-21.html	4.92 KB	-rw-r--r--
release-8-3-22.html	10.34 KB	-rw-r--r--
release-8-3-23.html	6.14 KB	-rw-r--r--
release-8-3-3.html	4.17 KB	-rw-r--r--
release-8-3-4.html	11.01 KB	-rw-r--r--
release-8-3-5.html	8.49 KB	-rw-r--r--
release-8-3-6.html	8.98 KB	-rw-r--r--
release-8-3-7.html	9.5 KB	-rw-r--r--
release-8-3-8.html	9.04 KB	-rw-r--r--
release-8-3-9.html	9.97 KB	-rw-r--r--
release-8-3.html	68.14 KB	-rw-r--r--
release-8-4-1.html	9.34 KB	-rw-r--r--
release-8-4-10.html	11.65 KB	-rw-r--r--
release-8-4-11.html	13.46 KB	-rw-r--r--
release-8-4-12.html	9.75 KB	-rw-r--r--
release-8-4-13.html	9.49 KB	-rw-r--r--
release-8-4-14.html	5 KB	-rw-r--r--
release-8-4-15.html	10.38 KB	-rw-r--r--
release-8-4-16.html	7.16 KB	-rw-r--r--
release-8-4-17.html	9.35 KB	-rw-r--r--
release-8-4-18.html	6.88 KB	-rw-r--r--
release-8-4-19.html	7.6 KB	-rw-r--r--
release-8-4-2.html	15.33 KB	-rw-r--r--
release-8-4-20.html	15.88 KB	-rw-r--r--
release-8-4-21.html	5.32 KB	-rw-r--r--
release-8-4-22.html	11.04 KB	-rw-r--r--
release-8-4-3.html	13.6 KB	-rw-r--r--
release-8-4-4.html	10.48 KB	-rw-r--r--
release-8-4-5.html	15.56 KB	-rw-r--r--
release-8-4-6.html	10.19 KB	-rw-r--r--
release-8-4-7.html	6.07 KB	-rw-r--r--
release-8-4-8.html	8.64 KB	-rw-r--r--
release-8-4-9.html	14.19 KB	-rw-r--r--
release-8-4.html	85.91 KB	-rw-r--r--
release-9-0-1.html	5.81 KB	-rw-r--r--
release-9-0-10.html	5.56 KB	-rw-r--r--
release-9-0-11.html	12.37 KB	-rw-r--r--
release-9-0-12.html	8.62 KB	-rw-r--r--
release-9-0-13.html	11.4 KB	-rw-r--r--
release-9-0-14.html	8.55 KB	-rw-r--r--
release-9-0-15.html	8.93 KB	-rw-r--r--
release-9-0-16.html	17 KB	-rw-r--r--
release-9-0-17.html	6.19 KB	-rw-r--r--
release-9-0-18.html	11.6 KB	-rw-r--r--
release-9-0-19.html	25.99 KB	-rw-r--r--
release-9-0-2.html	13.32 KB	-rw-r--r--
release-9-0-20.html	15.46 KB	-rw-r--r--
release-9-0-21.html	5.04 KB	-rw-r--r--
release-9-0-22.html	4.22 KB	-rw-r--r--
release-9-0-23.html	15.78 KB	-rw-r--r--
release-9-0-3.html	7.09 KB	-rw-r--r--
release-9-0-4.html	11.08 KB	-rw-r--r--
release-9-0-5.html	17.5 KB	-rw-r--r--
release-9-0-6.html	13.11 KB	-rw-r--r--
release-9-0-7.html	17.67 KB	-rw-r--r--
release-9-0-8.html	10.74 KB	-rw-r--r--
release-9-0-9.html	11.47 KB	-rw-r--r--
release-9-0.html	93.87 KB	-rw-r--r--
release-9-1-1.html	3.58 KB	-rw-r--r--
release-9-1-10.html	10.11 KB	-rw-r--r--
release-9-1-11.html	9.36 KB	-rw-r--r--
release-9-1-12.html	18.12 KB	-rw-r--r--
release-9-1-13.html	6.53 KB	-rw-r--r--
release-9-1-14.html	12.73 KB	-rw-r--r--
release-9-1-15.html	28.29 KB	-rw-r--r--
release-9-1-16.html	18.67 KB	-rw-r--r--
release-9-1-17.html	4.83 KB	-rw-r--r--
release-9-1-18.html	4.01 KB	-rw-r--r--
release-9-1-19.html	17.2 KB	-rw-r--r--
release-9-1-2.html	21.07 KB	-rw-r--r--
release-9-1-20.html	17.13 KB	-rw-r--r--
release-9-1-21.html	7.42 KB	-rw-r--r--
release-9-1-22.html	7.09 KB	-rw-r--r--
release-9-1-23.html	12.36 KB	-rw-r--r--
release-9-1-24.html	8.53 KB	-rw-r--r--
release-9-1-3.html	20.66 KB	-rw-r--r--
release-9-1-4.html	15.64 KB	-rw-r--r--
release-9-1-5.html	13.71 KB	-rw-r--r--
release-9-1-6.html	9.3 KB	-rw-r--r--
release-9-1-7.html	14.59 KB	-rw-r--r--
release-9-1-8.html	9.92 KB	-rw-r--r--
release-9-1-9.html	12.38 KB	-rw-r--r--
release-9-1.html	77.11 KB	-rw-r--r--
release-9-2-1.html	6.94 KB	-rw-r--r--
release-9-2-10.html	31.61 KB	-rw-r--r--
release-9-2-11.html	19.82 KB	-rw-r--r--
release-9-2-12.html	5.01 KB	-rw-r--r--
release-9-2-13.html	4.01 KB	-rw-r--r--
release-9-2-14.html	17.96 KB	-rw-r--r--
release-9-2-15.html	18.17 KB	-rw-r--r--
release-9-2-16.html	7.42 KB	-rw-r--r--
release-9-2-17.html	8 KB	-rw-r--r--
release-9-2-18.html	12.42 KB	-rw-r--r--
release-9-2-19.html	10.27 KB	-rw-r--r--
release-9-2-2.html	22.46 KB	-rw-r--r--
release-9-2-20.html	13.02 KB	-rw-r--r--
release-9-2-21.html	13.87 KB	-rw-r--r--
release-9-2-22.html	15.49 KB	-rw-r--r--
release-9-2-23.html	7.94 KB	-rw-r--r--
release-9-2-24.html	7.69 KB	-rw-r--r--
release-9-2-3.html	13.06 KB	-rw-r--r--
release-9-2-4.html	14.45 KB	-rw-r--r--
release-9-2-5.html	11.72 KB	-rw-r--r--
release-9-2-6.html	11.41 KB	-rw-r--r--
release-9-2-7.html	19.55 KB	-rw-r--r--
release-9-2-8.html	7.2 KB	-rw-r--r--
release-9-2-9.html	15.25 KB	-rw-r--r--
release-9-2.html	77.66 KB	-rw-r--r--
release.html	22.35 KB	-rw-r--r--
resources.html	4.13 KB	-rw-r--r--
role-attributes.html	7.67 KB	-rw-r--r--
role-membership.html	8.19 KB	-rw-r--r--
role-removal.html	5.18 KB	-rw-r--r--
routine-reindex.html	3.54 KB	-rw-r--r--
routine-vacuuming.html	37.13 KB	-rw-r--r--
row-estimation-examples.html	20.28 KB	-rw-r--r--
rowtypes.html	22.86 KB	-rw-r--r--
rule-system.html	4.02 KB	-rw-r--r--
rules-privileges.html	11.39 KB	-rw-r--r--
rules-status.html	4.41 KB	-rw-r--r--
rules-triggers.html	9.25 KB	-rw-r--r--
rules-update.html	31.85 KB	-rw-r--r--
rules-views.html	26.26 KB	-rw-r--r--
rules.html	4.83 KB	-rw-r--r--
runtime-config-autovacuum.html	10.72 KB	-rw-r--r--
runtime-config-client.html	32.05 KB	-rw-r--r--
runtime-config-compatible.html	14.48 KB	-rw-r--r--
runtime-config-connection.html	22.93 KB	-rw-r--r--
runtime-config-custom.html	3.46 KB	-rw-r--r--
runtime-config-developer.html	13.74 KB	-rw-r--r--
runtime-config-error-handling....	3.49 KB	-rw-r--r--
runtime-config-file-locations....	6.81 KB	-rw-r--r--
runtime-config-locks.html	7.46 KB	-rw-r--r--
runtime-config-logging.html	44.38 KB	-rw-r--r--
runtime-config-preset.html	8.51 KB	-rw-r--r--
runtime-config-query.html	24.37 KB	-rw-r--r--
runtime-config-replication.htm...	17.87 KB	-rw-r--r--
runtime-config-resource.html	27.25 KB	-rw-r--r--
runtime-config-short.html	6.53 KB	-rw-r--r--
runtime-config-statistics.html	8.41 KB	-rw-r--r--
runtime-config-wal.html	26.46 KB	-rw-r--r--
runtime-config.html	8.06 KB	-rw-r--r--
runtime.html	5.12 KB	-rw-r--r--
seg.html	15.11 KB	-rw-r--r--
sepgsql.html	30.11 KB	-rw-r--r--
server-programming.html	9.39 KB	-rw-r--r--
server-shutdown.html	6.32 KB	-rw-r--r--
server-start.html	13.88 KB	-rw-r--r--
source-format.html	5.01 KB	-rw-r--r--
source.html	3.98 KB	-rw-r--r--
sourcerepo.html	3.33 KB	-rw-r--r--
spgist-examples.html	2.64 KB	-rw-r--r--
spgist-extensibility.html	30.55 KB	-rw-r--r--
spgist-implementation.html	7.91 KB	-rw-r--r--
spgist-intro.html	4.22 KB	-rw-r--r--
spgist.html	2.9 KB	-rw-r--r--
spi-examples.html	6.07 KB	-rw-r--r--
spi-interface-support.html	3.68 KB	-rw-r--r--
spi-interface.html	5.86 KB	-rw-r--r--
spi-memory.html	6.92 KB	-rw-r--r--
spi-realloc.html	3.54 KB	-rw-r--r--
spi-spi-connect.html	3.96 KB	-rw-r--r--
spi-spi-copytuple.html	3.37 KB	-rw-r--r--
spi-spi-cursor-close.html	3.26 KB	-rw-r--r--
spi-spi-cursor-fetch.html	4.01 KB	-rw-r--r--
spi-spi-cursor-find.html	3.38 KB	-rw-r--r--
spi-spi-cursor-move.html	3.8 KB	-rw-r--r--
spi-spi-cursor-open-with-args....	6.03 KB	-rw-r--r--
spi-spi-cursor-open-with-param...	4.92 KB	-rw-r--r--
spi-spi-cursor-open.html	5.6 KB	-rw-r--r--
spi-spi-exec.html	3.51 KB	-rw-r--r--
spi-spi-execp.html	4.75 KB	-rw-r--r--
spi-spi-execute-plan-with-para...	4.78 KB	-rw-r--r--
spi-spi-execute-plan.html	5.76 KB	-rw-r--r--
spi-spi-execute-with-args.html	6.08 KB	-rw-r--r--
spi-spi-execute.html	12.3 KB	-rw-r--r--
spi-spi-finish.html	3.57 KB	-rw-r--r--
spi-spi-fname.html	3.68 KB	-rw-r--r--
spi-spi-fnumber.html	3.84 KB	-rw-r--r--
spi-spi-freeplan.html	3.42 KB	-rw-r--r--
spi-spi-freetuple.html	3.2 KB	-rw-r--r--
spi-spi-freetupletable.html	3.54 KB	-rw-r--r--
spi-spi-getargcount.html	3.61 KB	-rw-r--r--
spi-spi-getargtypeid.html	4.04 KB	-rw-r--r--
spi-spi-getbinval.html	4.19 KB	-rw-r--r--
spi-spi-getnspname.html	3.39 KB	-rw-r--r--
spi-spi-getrelname.html	3.27 KB	-rw-r--r--
spi-spi-gettype.html	3.63 KB	-rw-r--r--
spi-spi-gettypeid.html	3.63 KB	-rw-r--r--
spi-spi-getvalue.html	4.07 KB	-rw-r--r--
spi-spi-is-cursor-plan.html	4.45 KB	-rw-r--r--
spi-spi-keepplan.html	3.79 KB	-rw-r--r--
spi-spi-modifytuple.html	5.5 KB	-rw-r--r--
spi-spi-palloc.html	3.08 KB	-rw-r--r--
spi-spi-pfree.html	3.2 KB	-rw-r--r--
spi-spi-pop.html	2.68 KB	-rw-r--r--
spi-spi-prepare-cursor.html	4.94 KB	-rw-r--r--
spi-spi-prepare-params.html	4.31 KB	-rw-r--r--
spi-spi-prepare.html	7.48 KB	-rw-r--r--
spi-spi-push.html	3.65 KB	-rw-r--r--
spi-spi-returntuple.html	4 KB	-rw-r--r--
spi-spi-saveplan.html	4.47 KB	-rw-r--r--
spi-spi-scroll-cursor-fetch.ht...	4.7 KB	-rw-r--r--
spi-spi-scroll-cursor-move.htm...	4.78 KB	-rw-r--r--
spi-visibility.html	4.05 KB	-rw-r--r--
spi.html	10.59 KB	-rw-r--r--
sql-abort.html	4.08 KB	-rw-r--r--
sql-alteraggregate.html	5.97 KB	-rw-r--r--
sql-altercollation.html	4.96 KB	-rw-r--r--
sql-alterconversion.html	5.05 KB	-rw-r--r--
sql-alterdatabase.html	8.57 KB	-rw-r--r--
sql-alterdefaultprivileges.htm...	9.19 KB	-rw-r--r--
sql-alterdomain.html	10.85 KB	-rw-r--r--
sql-alterextension.html	11.47 KB	-rw-r--r--
sql-alterforeigndatawrapper.ht...	7.21 KB	-rw-r--r--
sql-alterforeigntable.html	12.41 KB	-rw-r--r--
sql-alterfunction.html	12.54 KB	-rw-r--r--
sql-altergroup.html	5.12 KB	-rw-r--r--
sql-alterindex.html	7.48 KB	-rw-r--r--
sql-alterlanguage.html	3.93 KB	-rw-r--r--
sql-alterlargeobject.html	3.64 KB	-rw-r--r--
sql-alteropclass.html	4.99 KB	-rw-r--r--
sql-alteroperator.html	5.31 KB	-rw-r--r--
sql-alteropfamily.html	13.25 KB	-rw-r--r--
sql-alterrole.html	12.72 KB	-rw-r--r--
sql-alterschema.html	4.21 KB	-rw-r--r--
sql-altersequence.html	12.73 KB	-rw-r--r--
sql-alterserver.html	5.79 KB	-rw-r--r--
sql-altertable.html	42.52 KB	-rw-r--r--
sql-altertablespace.html	5.73 KB	-rw-r--r--
sql-altertrigger.html	4.54 KB	-rw-r--r--
sql-altertsconfig.html	7.94 KB	-rw-r--r--
sql-altertsdictionary.html	6.39 KB	-rw-r--r--
sql-altertsparser.html	4.16 KB	-rw-r--r--
sql-altertstemplate.html	4.12 KB	-rw-r--r--
sql-altertype.html	10.93 KB	-rw-r--r--
sql-alteruser.html	4.61 KB	-rw-r--r--
sql-alterusermapping.html	5.58 KB	-rw-r--r--
sql-alterview.html	6.81 KB	-rw-r--r--
sql-analyze.html	10.42 KB	-rw-r--r--
sql-begin.html	6.54 KB	-rw-r--r--
sql-checkpoint.html	3.67 KB	-rw-r--r--
sql-close.html	4.87 KB	-rw-r--r--
sql-cluster.html	9.18 KB	-rw-r--r--
sql-commands.html	18.37 KB	-rw-r--r--
sql-comment.html	13.48 KB	-rw-r--r--
sql-commit-prepared.html	4.41 KB	-rw-r--r--
sql-commit.html	3.9 KB	-rw-r--r--
sql-copy.html	36.57 KB	-rw-r--r--
sql-createaggregate.html	13.5 KB	-rw-r--r--
sql-createcast.html	19.17 KB	-rw-r--r--
sql-createcollation.html	6.58 KB	-rw-r--r--
sql-createconversion.html	6.38 KB	-rw-r--r--
sql-createdatabase.html	11.85 KB	-rw-r--r--
sql-createdomain.html	8.34 KB	-rw-r--r--
sql-createextension.html	8.87 KB	-rw-r--r--
sql-createforeigndatawrapper.h...	7.87 KB	-rw-r--r--
sql-createforeigntable.html	7.54 KB	-rw-r--r--
sql-createfunction.html	30.35 KB	-rw-r--r--
sql-creategroup.html	3.92 KB	-rw-r--r--
sql-createindex.html	25.33 KB	-rw-r--r--
sql-createlanguage.html	14.54 KB	-rw-r--r--
sql-createopclass.html	12.38 KB	-rw-r--r--
sql-createoperator.html	10.44 KB	-rw-r--r--
sql-createopfamily.html	5.49 KB	-rw-r--r--
sql-createrole.html	18.87 KB	-rw-r--r--
sql-createrule.html	12.36 KB	-rw-r--r--
sql-createschema.html	8.12 KB	-rw-r--r--
sql-createsequence.html	13.54 KB	-rw-r--r--
sql-createserver.html	6.1 KB	-rw-r--r--
sql-createtable.html	57.79 KB	-rw-r--r--
sql-createtableas.html	12.47 KB	-rw-r--r--
sql-createtablespace.html	5.96 KB	-rw-r--r--
sql-createtrigger.html	22.63 KB	-rw-r--r--
sql-createtsconfig.html	5.23 KB	-rw-r--r--
sql-createtsdictionary.html	5.4 KB	-rw-r--r--
sql-createtsparser.html	5.81 KB	-rw-r--r--
sql-createtstemplate.html	5.31 KB	-rw-r--r--
sql-createtype.html	38.54 KB	-rw-r--r--
sql-createuser.html	4.42 KB	-rw-r--r--
sql-createusermapping.html	5.37 KB	-rw-r--r--
sql-createview.html	10.31 KB	-rw-r--r--
sql-deallocate.html	3.7 KB	-rw-r--r--
sql-declare.html	15.04 KB	-rw-r--r--
sql-delete.html	11.5 KB	-rw-r--r--
sql-discard.html	4.21 KB	-rw-r--r--
sql-do.html	5.08 KB	-rw-r--r--
sql-drop-owned.html	4.94 KB	-rw-r--r--
sql-dropaggregate.html	4.45 KB	-rw-r--r--
sql-dropcast.html	4.24 KB	-rw-r--r--
sql-dropcollation.html	4.31 KB	-rw-r--r--
sql-dropconversion.html	4.33 KB	-rw-r--r--
sql-dropdatabase.html	4.24 KB	-rw-r--r--
sql-dropdomain.html	4.16 KB	-rw-r--r--
sql-dropextension.html	4.67 KB	-rw-r--r--
sql-dropforeigndatawrapper.htm...	4.42 KB	-rw-r--r--
sql-dropforeigntable.html	4.45 KB	-rw-r--r--
sql-dropfunction.html	5.7 KB	-rw-r--r--
sql-dropgroup.html	2.98 KB	-rw-r--r--
sql-dropindex.html	5.06 KB	-rw-r--r--
sql-droplanguage.html	4.73 KB	-rw-r--r--
sql-dropopclass.html	5.54 KB	-rw-r--r--
sql-dropoperator.html	5.1 KB	-rw-r--r--
sql-dropopfamily.html	5.16 KB	-rw-r--r--
sql-droprole.html	5.04 KB	-rw-r--r--
sql-droprule.html	4.05 KB	-rw-r--r--
sql-dropschema.html	4.42 KB	-rw-r--r--
sql-dropsequence.html	4.26 KB	-rw-r--r--
sql-dropserver.html	4.17 KB	-rw-r--r--
sql-droptable.html	4.91 KB	-rw-r--r--
sql-droptablespace.html	4.48 KB	-rw-r--r--
sql-droptrigger.html	4.6 KB	-rw-r--r--
sql-droptsconfig.html	4.66 KB	-rw-r--r--
sql-droptsdictionary.html	4.58 KB	-rw-r--r--
sql-droptsparser.html	4.49 KB	-rw-r--r--
sql-droptstemplate.html	4.46 KB	-rw-r--r--
sql-droptype.html	4.36 KB	-rw-r--r--
sql-dropuser.html	3.11 KB	-rw-r--r--
sql-dropusermapping.html	4.57 KB	-rw-r--r--
sql-dropview.html	4.16 KB	-rw-r--r--
sql-end.html	4.06 KB	-rw-r--r--
sql-execute.html	4.95 KB	-rw-r--r--
sql-explain.html	16.69 KB	-rw-r--r--
sql-expressions.html	46.68 KB	-rw-r--r--
sql-fetch.html	13.92 KB	-rw-r--r--
sql-grant.html	28.56 KB	-rw-r--r--
sql-insert.html	12.56 KB	-rw-r--r--
sql-keywords-appendix.html	104.04 KB	-rw-r--r--
sql-listen.html	5.76 KB	-rw-r--r--
sql-load.html	4.11 KB	-rw-r--r--
sql-lock.html	11.59 KB	-rw-r--r--
sql-move.html	4.87 KB	-rw-r--r--
sql-notify.html	10.69 KB	-rw-r--r--
sql-prepare-transaction.html	8.44 KB	-rw-r--r--
sql-prepare.html	8.97 KB	-rw-r--r--
sql-reassign-owned.html	5.22 KB	-rw-r--r--
sql-reindex.html	10.84 KB	-rw-r--r--
sql-release-savepoint.html	4.89 KB	-rw-r--r--
sql-reset.html	4.88 KB	-rw-r--r--
sql-revoke.html	14.53 KB	-rw-r--r--
sql-rollback-prepared.html	4.52 KB	-rw-r--r--
sql-rollback-to.html	6.25 KB	-rw-r--r--
sql-rollback.html	3.9 KB	-rw-r--r--
sql-savepoint.html	5.47 KB	-rw-r--r--
sql-security-label.html	8.67 KB	-rw-r--r--
sql-select.html	77.68 KB	-rw-r--r--
sql-selectinto.html	7.46 KB	-rw-r--r--
sql-set-constraints.html	6.9 KB	-rw-r--r--
sql-set-role.html	6.75 KB	-rw-r--r--
sql-set-session-authorization....	5.92 KB	-rw-r--r--
sql-set-transaction.html	12.4 KB	-rw-r--r--
sql-set.html	11.77 KB	-rw-r--r--
sql-show.html	6.69 KB	-rw-r--r--
sql-start-transaction.html	4.87 KB	-rw-r--r--
sql-syntax-calling-funcs.html	7.89 KB	-rw-r--r--
sql-syntax-lexical.html	42.35 KB	-rw-r--r--
sql-syntax.html	5.3 KB	-rw-r--r--
sql-truncate.html	9.14 KB	-rw-r--r--
sql-unlisten.html	4.81 KB	-rw-r--r--
sql-update.html	15.3 KB	-rw-r--r--
sql-vacuum.html	10.42 KB	-rw-r--r--
sql-values.html	10.39 KB	-rw-r--r--
sql.html	13.25 KB	-rw-r--r--
ssh-tunnels.html	6.12 KB	-rw-r--r--
ssl-tcp.html	13.16 KB	-rw-r--r--
sslinfo.html	7.42 KB	-rw-r--r--
standby-settings.html	5.3 KB	-rw-r--r--
storage-file-layout.html	12.63 KB	-rw-r--r--
storage-fsm.html	3.73 KB	-rw-r--r--
storage-init.html	2.7 KB	-rw-r--r--
storage-page-layout.html	13.57 KB	-rw-r--r--
storage-toast.html	11.21 KB	-rw-r--r--
storage-vm.html	3.46 KB	-rw-r--r--
storage.html	2.88 KB	-rw-r--r--
stylesheet.css	1.5 KB	-rw-r--r--
supported-platforms.html	4.92 KB	-rw-r--r--
tablefunc.html	31.44 KB	-rw-r--r--
tcn.html	4.86 KB	-rw-r--r--
test-parser.html	4.42 KB	-rw-r--r--
textsearch-configuration.html	6.11 KB	-rw-r--r--
textsearch-controls.html	26.33 KB	-rw-r--r--
textsearch-debugging.html	16.82 KB	-rw-r--r--
textsearch-dictionaries.html	30.53 KB	-rw-r--r--
textsearch-features.html	20.81 KB	-rw-r--r--
textsearch-indexes.html	7.21 KB	-rw-r--r--
textsearch-intro.html	18.02 KB	-rw-r--r--
textsearch-limitations.html	3.77 KB	-rw-r--r--
textsearch-migration.html	4.92 KB	-rw-r--r--
textsearch-parsers.html	8.99 KB	-rw-r--r--
textsearch-psql.html	9.13 KB	-rw-r--r--
textsearch-tables.html	9.52 KB	-rw-r--r--
textsearch.html	5.74 KB	-rw-r--r--
transaction-iso.html	26.6 KB	-rw-r--r--
trigger-datachanges.html	4.95 KB	-rw-r--r--
trigger-definition.html	15.14 KB	-rw-r--r--
trigger-example.html	7.57 KB	-rw-r--r--
trigger-interface.html	10.47 KB	-rw-r--r--
triggers.html	3.71 KB	-rw-r--r--
tsearch2.html	9.72 KB	-rw-r--r--
tutorial-accessdb.html	6.88 KB	-rw-r--r--
tutorial-advanced-intro.html	3.26 KB	-rw-r--r--
tutorial-advanced.html	2.79 KB	-rw-r--r--
tutorial-agg.html	7.42 KB	-rw-r--r--
tutorial-arch.html	4.74 KB	-rw-r--r--
tutorial-concepts.html	3.75 KB	-rw-r--r--
tutorial-conclusion.html	2.78 KB	-rw-r--r--
tutorial-createdb.html	8.98 KB	-rw-r--r--
tutorial-delete.html	3.43 KB	-rw-r--r--
tutorial-fk.html	4.32 KB	-rw-r--r--
tutorial-inheritance.html	5.99 KB	-rw-r--r--
tutorial-install.html	4.42 KB	-rw-r--r--
tutorial-join.html	9.46 KB	-rw-r--r--
tutorial-populate.html	4.73 KB	-rw-r--r--
tutorial-select.html	7.84 KB	-rw-r--r--
tutorial-sql-intro.html	4.79 KB	-rw-r--r--
tutorial-sql.html	2.99 KB	-rw-r--r--
tutorial-start.html	2.57 KB	-rw-r--r--
tutorial-table.html	5.57 KB	-rw-r--r--
tutorial-transactions.html	9.71 KB	-rw-r--r--
tutorial-update.html	3.08 KB	-rw-r--r--
tutorial-views.html	3.3 KB	-rw-r--r--
tutorial-window.html	12.19 KB	-rw-r--r--
tutorial.html	5.09 KB	-rw-r--r--
typeconv-func.html	11.88 KB	-rw-r--r--
typeconv-oper.html	14.56 KB	-rw-r--r--
typeconv-overview.html	8.11 KB	-rw-r--r--
typeconv-query.html	5.32 KB	-rw-r--r--
typeconv-union-case.html	6.46 KB	-rw-r--r--
typeconv.html	3.63 KB	-rw-r--r--
unaccent.html	6.58 KB	-rw-r--r--
unsupported-features-sql-stand...	34.29 KB	-rw-r--r--
upgrading.html	12.5 KB	-rw-r--r--
user-manag.html	3.89 KB	-rw-r--r--
using-explain.html	40.84 KB	-rw-r--r--
uuid-ossp.html	7.06 KB	-rw-r--r--
vacuumlo.html	7.37 KB	-rw-r--r--
view-pg-available-extension-ve...	4.53 KB	-rw-r--r--
view-pg-available-extensions.h...	3.85 KB	-rw-r--r--
view-pg-cursors.html	5.54 KB	-rw-r--r--
view-pg-group.html	3.81 KB	-rw-r--r--
view-pg-indexes.html	4.06 KB	-rw-r--r--
view-pg-locks.html	14.11 KB	-rw-r--r--
view-pg-prepared-statements.ht...	4.94 KB	-rw-r--r--
view-pg-prepared-xacts.html	4.8 KB	-rw-r--r--
view-pg-roles.html	5.93 KB	-rw-r--r--
view-pg-rules.html	3.91 KB	-rw-r--r--
view-pg-seclabels.html	5 KB	-rw-r--r--
view-pg-settings.html	10.35 KB	-rw-r--r--
view-pg-shadow.html	5.25 KB	-rw-r--r--
view-pg-stats.html	8.68 KB	-rw-r--r--
view-pg-tables.html	4.72 KB	-rw-r--r--
view-pg-timezone-abbrevs.html	3.77 KB	-rw-r--r--
view-pg-timezone-names.html	4.08 KB	-rw-r--r--
view-pg-user-mappings.html	5.04 KB	-rw-r--r--
view-pg-user.html	4.41 KB	-rw-r--r--
view-pg-views.html	3.76 KB	-rw-r--r--
views-overview.html	6.39 KB	-rw-r--r--
wal-async-commit.html	8.8 KB	-rw-r--r--
wal-configuration.html	14.61 KB	-rw-r--r--
wal-internals.html	6.01 KB	-rw-r--r--
wal-intro.html	5.4 KB	-rw-r--r--
wal-reliability.html	11.21 KB	-rw-r--r--
wal.html	2.86 KB	-rw-r--r--
warm-standby-failover.html	5.96 KB	-rw-r--r--
warm-standby.html	33.83 KB	-rw-r--r--
xaggr.html	9.67 KB	-rw-r--r--
xfunc-c.html	76.68 KB	-rw-r--r--
xfunc-internal.html	3.91 KB	-rw-r--r--
xfunc-overload.html	5.77 KB	-rw-r--r--
xfunc-pl.html	2.92 KB	-rw-r--r--
xfunc-sql.html	37.14 KB	-rw-r--r--
xfunc-volatility.html	9.61 KB	-rw-r--r--
xfunc.html	4.41 KB	-rw-r--r--
xindex.html	43.55 KB	-rw-r--r--
xml2.html	16.5 KB	-rw-r--r--
xoper-optimization.html	22.6 KB	-rw-r--r--
xoper.html	4.72 KB	-rw-r--r--
xplang-install.html	10.87 KB	-rw-r--r--
xplang.html	4.14 KB	-rw-r--r--
xtypes.html	11.83 KB	-rw-r--r--

Code Editor : ecpg-pgtypes.html

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML
><HEAD
><TITLE
>pgtypes Library</TITLE
><META
NAME="GENERATOR"
CONTENT="Modular DocBook HTML Stylesheet Version 1.79"><LINK
REV="MADE"
HREF="mailto:pgsql-docs@postgresql.org"><LINK
REL="HOME"
TITLE="PostgreSQL 9.2.24 Documentation"
HREF="index.html"><LINK
REL="UP"
TITLE="ECPG - Embedded SQL in C"
HREF="ecpg.html"><LINK
REL="PREVIOUS"
TITLE="Dynamic SQL"
HREF="ecpg-dynamic.html"><LINK
REL="NEXT"
TITLE="Using Descriptor Areas"
HREF="ecpg-descriptors.html"><LINK
REL="STYLESHEET"
TYPE="text/css"
HREF="stylesheet.css"><META
HTTP-EQUIV="Content-Type"
CONTENT="text/html; charset=ISO-8859-1"><META
NAME="creation"
CONTENT="2017-11-06T22:43:11"></HEAD
><BODY
CLASS="SECT1"
><DIV
CLASS="NAVHEADER"
><TABLE
SUMMARY="Header navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TH
COLSPAN="5"
ALIGN="center"
VALIGN="bottom"
><A
HREF="index.html"
>PostgreSQL 9.2.24 Documentation</A
></TH
></TR
><TR
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
TITLE="Dynamic SQL"
HREF="ecpg-dynamic.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="10%"
ALIGN="left"
VALIGN="top"
><A
HREF="ecpg.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="60%"
ALIGN="center"
VALIGN="bottom"
>Chapter 33. ECPG - Embedded <ACRONYM
CLASS="ACRONYM"
>SQL</ACRONYM
> in C</TD
><TD
WIDTH="20%"
ALIGN="right"
VALIGN="top"
><A
TITLE="Using Descriptor Areas"
HREF="ecpg-descriptors.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
></TABLE
><HR
ALIGN="LEFT"
WIDTH="100%"></DIV
><DIV
CLASS="SECT1"
><H1
CLASS="SECT1"
><A
NAME="ECPG-PGTYPES"
>33.6. pgtypes Library</A
></H1
> The pgtypes library maps PostgreSQL database
 types to C equivalents that can be used in C programs. It also offers
 functions to do basic calculations with those types within C, i.e., without
 the help of the PostgreSQL server. See the
 following example:
<PRE
CLASS="PROGRAMLISTING"
>EXEC SQL BEGIN DECLARE SECTION;
 date date1;
 timestamp ts1, tsout;
 interval iv1;
 char *out;
EXEC SQL END DECLARE SECTION;

PGTYPESdate_today(&#38;date1);
EXEC SQL SELECT started, duration INTO :ts1, :iv1 FROM datetbl WHERE d=:date1;
PGTYPEStimestamp_add_interval(&#38;ts1, &#38;iv1, &#38;tsout);
out = PGTYPEStimestamp_to_asc(&#38;tsout);
printf("Started + duration: %s\n", out);
free(out);</PRE
>
 <DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="ECPG-PGTYPES-NUMERIC"
>33.6.1. The numeric Type</A
></H2
> The numeric type offers to do calculations with arbitrary precision. See
 <A
HREF="datatype-numeric.html"
>Section 8.1</A
> for the equivalent type in the
 PostgreSQL server. Because of the arbitrary precision this
 variable needs to be able to expand and shrink dynamically. That's why you
 can only create numeric variables on the heap, by means of the
 <CODE
CLASS="FUNCTION"
>PGTYPESnumeric_new</CODE
> and <CODE
CLASS="FUNCTION"
>PGTYPESnumeric_free</CODE
>
 functions. The decimal type, which is similar but limited in precision,
 can be created on the stack as well as on the heap.
 The following functions can be used to work with the numeric type:
 <DIV
CLASS="VARIABLELIST"
><DL
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_new</CODE
></DT
><DD
> Request a pointer to a newly allocated numeric variable.
<PRE
CLASS="SYNOPSIS"
>numeric *PGTYPESnumeric_new(void);</PRE
>
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_free</CODE
></DT
><DD
> Free a numeric type, release all of its memory.
<PRE
CLASS="SYNOPSIS"
>void PGTYPESnumeric_free(numeric *var);</PRE
>
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_from_asc</CODE
></DT
><DD
> Parse a numeric type from its string notation.
<PRE
CLASS="SYNOPSIS"
>numeric *PGTYPESnumeric_from_asc(char *str, char **endptr);</PRE
>
 Valid formats are for example:
 <TT
CLASS="LITERAL"
>-2</TT
>,
 <TT
CLASS="LITERAL"
>.794</TT
>,
 <TT
CLASS="LITERAL"
>+3.44</TT
>,
 <TT
CLASS="LITERAL"
>592.49E07</TT
> or
 <TT
CLASS="LITERAL"
>-32.84e-4</TT
>.
 If the value could be parsed successfully, a valid pointer is returned,
 else the NULL pointer. At the moment ECPG always parses the complete
 string and so it currently does not support to store the address of the
 first invalid character in <TT
CLASS="LITERAL"
>*endptr</TT
>. You can safely
 set <TT
CLASS="LITERAL"
>endptr</TT
> to NULL.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_to_asc</CODE
></DT
><DD
> Returns a pointer to a string allocated by <CODE
CLASS="FUNCTION"
>malloc</CODE
> that contains the string
 representation of the numeric type <TT
CLASS="LITERAL"
>num</TT
>.
<PRE
CLASS="SYNOPSIS"
>char *PGTYPESnumeric_to_asc(numeric *num, int dscale);</PRE
>
 The numeric value will be printed with <TT
CLASS="LITERAL"
>dscale</TT
> decimal
 digits, with rounding applied if necessary.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_add</CODE
></DT
><DD
> Add two numeric variables into a third one.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_add(numeric *var1, numeric *var2, numeric *result);</PRE
>
 The function adds the variables <TT
CLASS="LITERAL"
>var1</TT
> and
 <TT
CLASS="LITERAL"
>var2</TT
> into the result variable
 <TT
CLASS="LITERAL"
>result</TT
>.
 The function returns 0 on success and -1 in case of error.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_sub</CODE
></DT
><DD
> Subtract two numeric variables and return the result in a third one.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_sub(numeric *var1, numeric *var2, numeric *result);</PRE
>
 The function subtracts the variable <TT
CLASS="LITERAL"
>var2</TT
> from
 the variable <TT
CLASS="LITERAL"
>var1</TT
>. The result of the operation is
 stored in the variable <TT
CLASS="LITERAL"
>result</TT
>.
 The function returns 0 on success and -1 in case of error.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_mul</CODE
></DT
><DD
> Multiply two numeric variables and return the result in a third one.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_mul(numeric *var1, numeric *var2, numeric *result);</PRE
>
 The function multiplies the variables <TT
CLASS="LITERAL"
>var1</TT
> and
 <TT
CLASS="LITERAL"
>var2</TT
>. The result of the operation is stored in the
 variable <TT
CLASS="LITERAL"
>result</TT
>.
 The function returns 0 on success and -1 in case of error.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_div</CODE
></DT
><DD
> Divide two numeric variables and return the result in a third one.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_div(numeric *var1, numeric *var2, numeric *result);</PRE
>
 The function divides the variables <TT
CLASS="LITERAL"
>var1</TT
> by
 <TT
CLASS="LITERAL"
>var2</TT
>. The result of the operation is stored in the
 variable <TT
CLASS="LITERAL"
>result</TT
>.
 The function returns 0 on success and -1 in case of error.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_cmp</CODE
></DT
><DD
> Compare two numeric variables.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_cmp(numeric *var1, numeric *var2)</PRE
>
 This function compares two numeric variables. In case of error,
 <TT
CLASS="LITERAL"
>INT_MAX</TT
> is returned. On success, the function
 returns one of three possible results:
 <UL
><LI
> 1, if <TT
CLASS="LITERAL"
>var1</TT
> is bigger than <TT
CLASS="LITERAL"
>var2</TT
>
 </LI
><LI
> -1, if <TT
CLASS="LITERAL"
>var1</TT
> is smaller than <TT
CLASS="LITERAL"
>var2</TT
>
 </LI
><LI
> 0, if <TT
CLASS="LITERAL"
>var1</TT
> and <TT
CLASS="LITERAL"
>var2</TT
> are equal
 </LI
></UL
>
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_from_int</CODE
></DT
><DD
> Convert an int variable to a numeric variable.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_from_int(signed int int_val, numeric *var);</PRE
>
 This function accepts a variable of type signed int and stores it
 in the numeric variable <TT
CLASS="LITERAL"
>var</TT
>. Upon success, 0 is returned and
 -1 in case of a failure.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_from_long</CODE
></DT
><DD
> Convert a long int variable to a numeric variable.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_from_long(signed long int long_val, numeric *var);</PRE
>
 This function accepts a variable of type signed long int and stores it
 in the numeric variable <TT
CLASS="LITERAL"
>var</TT
>. Upon success, 0 is returned and
 -1 in case of a failure.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_copy</CODE
></DT
><DD
> Copy over one numeric variable into another one.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_copy(numeric *src, numeric *dst);</PRE
>
 This function copies over the value of the variable that
 <TT
CLASS="LITERAL"
>src</TT
> points to into the variable that <TT
CLASS="LITERAL"
>dst</TT
>
 points to. It returns 0 on success and -1 if an error occurs.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_from_double</CODE
></DT
><DD
> Convert a variable of type double to a numeric.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_from_double(double d, numeric *dst);</PRE
>
 This function accepts a variable of type double and stores the result
 in the variable that <TT
CLASS="LITERAL"
>dst</TT
> points to. It returns 0 on success
 and -1 if an error occurs.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_to_double</CODE
></DT
><DD
> Convert a variable of type numeric to double.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_to_double(numeric *nv, double *dp)</PRE
>
 The function converts the numeric value from the variable that
 <TT
CLASS="LITERAL"
>nv</TT
> points to into the double variable that <TT
CLASS="LITERAL"
>dp</TT
> points
 to. It returns 0 on success and -1 if an error occurs, including
 overflow. On overflow, the global variable <TT
CLASS="LITERAL"
>errno</TT
> will be set
 to <TT
CLASS="LITERAL"
>PGTYPES_NUM_OVERFLOW</TT
> additionally.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_to_int</CODE
></DT
><DD
> Convert a variable of type numeric to int.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_to_int(numeric *nv, int *ip);</PRE
>
 The function converts the numeric value from the variable that
 <TT
CLASS="LITERAL"
>nv</TT
> points to into the integer variable that <TT
CLASS="LITERAL"
>ip</TT
>
 points to. It returns 0 on success and -1 if an error occurs, including
 overflow. On overflow, the global variable <TT
CLASS="LITERAL"
>errno</TT
> will be set
 to <TT
CLASS="LITERAL"
>PGTYPES_NUM_OVERFLOW</TT
> additionally.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_to_long</CODE
></DT
><DD
> Convert a variable of type numeric to long.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_to_long(numeric *nv, long *lp);</PRE
>
 The function converts the numeric value from the variable that
 <TT
CLASS="LITERAL"
>nv</TT
> points to into the long integer variable that
 <TT
CLASS="LITERAL"
>lp</TT
> points to. It returns 0 on success and -1 if an error
 occurs, including overflow. On overflow, the global variable
 <TT
CLASS="LITERAL"
>errno</TT
> will be set to <TT
CLASS="LITERAL"
>PGTYPES_NUM_OVERFLOW</TT
>
 additionally.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_to_decimal</CODE
></DT
><DD
> Convert a variable of type numeric to decimal.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_to_decimal(numeric *src, decimal *dst);</PRE
>
 The function converts the numeric value from the variable that
 <TT
CLASS="LITERAL"
>src</TT
> points to into the decimal variable that
 <TT
CLASS="LITERAL"
>dst</TT
> points to. It returns 0 on success and -1 if an error
 occurs, including overflow. On overflow, the global variable
 <TT
CLASS="LITERAL"
>errno</TT
> will be set to <TT
CLASS="LITERAL"
>PGTYPES_NUM_OVERFLOW</TT
>
 additionally.
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESnumeric_from_decimal</CODE
></DT
><DD
> Convert a variable of type decimal to numeric.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESnumeric_from_decimal(decimal *src, numeric *dst);</PRE
>
 The function converts the decimal value from the variable that
 <TT
CLASS="LITERAL"
>src</TT
> points to into the numeric variable that
 <TT
CLASS="LITERAL"
>dst</TT
> points to. It returns 0 on success and -1 if an error
 occurs. Since the decimal type is implemented as a limited version of
 the numeric type, overflow cannot occur with this conversion.
 </DD
></DL
></DIV
>
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="ECPG-PGTYPES-DATE"
>33.6.2. The date Type</A
></H2
> The date type in C enables your programs to deal with data of the SQL type
 date. See <A
HREF="datatype-datetime.html"
>Section 8.5</A
> for the equivalent type in the
 PostgreSQL server.
 The following functions can be used to work with the date type:
 <DIV
CLASS="VARIABLELIST"
><DL
><DT
><A
NAME="PGTYPESDATEFROMTIMESTAMP"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_from_timestamp</CODE
></DT
><DD
> Extract the date part from a timestamp.
<PRE
CLASS="SYNOPSIS"
>date PGTYPESdate_from_timestamp(timestamp dt);</PRE
>
 The function receives a timestamp as its only argument and returns the
 extracted date part from this timestamp.
 </DD
><DT
><A
NAME="PGTYPESDATEFROMASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_from_asc</CODE
></DT
><DD
> Parse a date from its textual representation.
<PRE
CLASS="SYNOPSIS"
>date PGTYPESdate_from_asc(char *str, char **endptr);</PRE
>
 The function receives a C char* string <TT
CLASS="LITERAL"
>str</TT
> and a pointer to
 a C char* string <TT
CLASS="LITERAL"
>endptr</TT
>. At the moment ECPG always parses
 the complete string and so it currently does not support to store the
 address of the first invalid character in <TT
CLASS="LITERAL"
>*endptr</TT
>.
 You can safely set <TT
CLASS="LITERAL"
>endptr</TT
> to NULL.
 Note that the function always assumes MDY-formatted dates and there is
 currently no variable to change that within ECPG.
 <A
HREF="ecpg-pgtypes.html#ECPG-PGTYPESDATE-FROM-ASC-TABLE"
>Table 33-2</A
> shows the allowed input formats.
 <DIV
CLASS="TABLE"
><A
NAME="ECPG-PGTYPESDATE-FROM-ASC-TABLE"
></A
>Table 33-2. Valid Input Formats for <CODE
CLASS="FUNCTION"
>PGTYPESdate_from_asc</CODE
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
>Input</TH
><TH
>Result</TH
></TR
></THEAD
><TBODY
><TR
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>1999-01-08</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>1/8/1999</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>1/18/1999</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 18, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>01/02/03</TT
></TD
><TD
><TT
CLASS="LITERAL"
>February 1, 2003</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>1999-Jan-08</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>Jan-08-1999</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>08-Jan-1999</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>99-Jan-08</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>08-Jan-99</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>08-Jan-06</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 2006</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>Jan-08-99</TT
></TD
><TD
><TT
CLASS="LITERAL"
>January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>19990108</TT
></TD
><TD
><TT
CLASS="LITERAL"
>ISO 8601; January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>990108</TT
></TD
><TD
><TT
CLASS="LITERAL"
>ISO 8601; January 8, 1999</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>1999.008</TT
></TD
><TD
><TT
CLASS="LITERAL"
>year and day of year</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>J2451187</TT
></TD
><TD
><TT
CLASS="LITERAL"
>Julian day</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>January 8, 99 BC</TT
></TD
><TD
><TT
CLASS="LITERAL"
>year 99 before the Common Era</TT
></TD
></TR
></TBODY
></TABLE
></DIV
></DD
><DT
><A
NAME="PGTYPESDATETOASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_to_asc</CODE
></DT
><DD
> Return the textual representation of a date variable.
<PRE
CLASS="SYNOPSIS"
>char *PGTYPESdate_to_asc(date dDate);</PRE
>
 The function receives the date <TT
CLASS="LITERAL"
>dDate</TT
> as its only parameter.
 It will output the date in the form <TT
CLASS="LITERAL"
>1999-01-18</TT
>, i.e., in the
 <TT
CLASS="LITERAL"
>YYYY-MM-DD</TT
> format.
 </DD
><DT
><A
NAME="PGTYPESDATEJULMDY"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_julmdy</CODE
></DT
><DD
> Extract the values for the day, the month and the year from a variable
 of type date.
<PRE
CLASS="SYNOPSIS"
>void PGTYPESdate_julmdy(date d, int *mdy);</PRE
>
 
 The function receives the date <TT
CLASS="LITERAL"
>d</TT
> and a pointer to an array
 of 3 integer values <TT
CLASS="LITERAL"
>mdy</TT
>. The variable name indicates
 the sequential order: <TT
CLASS="LITERAL"
>mdy[0]</TT
> will be set to contain the
 number of the month, <TT
CLASS="LITERAL"
>mdy[1]</TT
> will be set to the value of the
 day and <TT
CLASS="LITERAL"
>mdy[2]</TT
> will contain the year.
 </DD
><DT
><A
NAME="PGTYPESDATEMDYJUL"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_mdyjul</CODE
></DT
><DD
> Create a date value from an array of 3 integers that specify the
 day, the month and the year of the date.
<PRE
CLASS="SYNOPSIS"
>void PGTYPESdate_mdyjul(int *mdy, date *jdate);</PRE
>
 The function receives the array of the 3 integers (<TT
CLASS="LITERAL"
>mdy</TT
>) as
 its first argument and as its second argument a pointer to a variable
 of type date that should hold the result of the operation.
 </DD
><DT
><A
NAME="PGTYPESDATEDAYOFWEEK"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_dayofweek</CODE
></DT
><DD
> Return a number representing the day of the week for a date value.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESdate_dayofweek(date d);</PRE
>
 The function receives the date variable <TT
CLASS="LITERAL"
>d</TT
> as its only
 argument and returns an integer that indicates the day of the week for
 this date.
 <UL
><LI
> 0 - Sunday
 </LI
><LI
> 1 - Monday
 </LI
><LI
> 2 - Tuesday
 </LI
><LI
> 3 - Wednesday
 </LI
><LI
> 4 - Thursday
 </LI
><LI
> 5 - Friday
 </LI
><LI
> 6 - Saturday
 </LI
></UL
>
 </DD
><DT
><A
NAME="PGTYPESDATETODAY"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_today</CODE
></DT
><DD
> Get the current date.
<PRE
CLASS="SYNOPSIS"
>void PGTYPESdate_today(date *d);</PRE
>
 The function receives a pointer to a date variable (<TT
CLASS="LITERAL"
>d</TT
>)
 that it sets to the current date.
 </DD
><DT
><A
NAME="PGTYPESDATEFMTASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_fmt_asc</CODE
></DT
><DD
> Convert a variable of type date to its textual representation using a
 format mask.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESdate_fmt_asc(date dDate, char *fmtstring, char *outbuf);</PRE
>
 The function receives the date to convert (<TT
CLASS="LITERAL"
>dDate</TT
>), the
 format mask (<TT
CLASS="LITERAL"
>fmtstring</TT
>) and the string that will hold the
 textual representation of the date (<TT
CLASS="LITERAL"
>outbuf</TT
>).
 On success, 0 is returned and a negative value if an error occurred.
 The following literals are the field specifiers you can use:
 <UL
><LI
> <TT
CLASS="LITERAL"
>dd</TT
> - The number of the day of the month.
 </LI
><LI
> <TT
CLASS="LITERAL"
>mm</TT
> - The number of the month of the year.
 </LI
><LI
> <TT
CLASS="LITERAL"
>yy</TT
> - The number of the year as a two digit number.
 </LI
><LI
> <TT
CLASS="LITERAL"
>yyyy</TT
> - The number of the year as a four digit number.
 </LI
><LI
> <TT
CLASS="LITERAL"
>ddd</TT
> - The name of the day (abbreviated).
 </LI
><LI
> <TT
CLASS="LITERAL"
>mmm</TT
> - The name of the month (abbreviated).
 </LI
></UL
>
 All other characters are copied 1:1 to the output string.
 <A
HREF="ecpg-pgtypes.html#ECPG-PGTYPESDATE-FMT-ASC-EXAMPLE-TABLE"
>Table 33-3</A
> indicates a few possible formats. This will give
 you an idea of how to use this function. All output lines are based on
 the same date: November 23, 1959.
 <DIV
CLASS="TABLE"
><A
NAME="ECPG-PGTYPESDATE-FMT-ASC-EXAMPLE-TABLE"
></A
>Table 33-3. Valid Input Formats for <CODE
CLASS="FUNCTION"
>PGTYPESdate_fmt_asc</CODE
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
>Format</TH
><TH
>Result</TH
></TR
></THEAD
><TBODY
><TR
><TD
><TT
CLASS="LITERAL"
>mmddyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>112359</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>ddmmyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>231159</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>yymmdd</TT
></TD
><TD
><TT
CLASS="LITERAL"
>591123</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>yy/mm/dd</TT
></TD
><TD
><TT
CLASS="LITERAL"
>59/11/23</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>yy mm dd</TT
></TD
><TD
><TT
CLASS="LITERAL"
>59 11 23</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>yy.mm.dd</TT
></TD
><TD
><TT
CLASS="LITERAL"
>59.11.23</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>.mm.yyyy.dd.</TT
></TD
><TD
><TT
CLASS="LITERAL"
>.11.1959.23.</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>mmm. dd, yyyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>Nov. 23, 1959</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>mmm dd yyyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>Nov 23 1959</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>yyyy dd mm</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1959 23 11</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>ddd, mmm. dd, yyyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>Mon, Nov. 23, 1959</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>(ddd) mmm. dd, yyyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>(Mon) Nov. 23, 1959</TT
></TD
></TR
></TBODY
></TABLE
></DIV
></DD
><DT
><A
NAME="PGTYPESDATEDEFMTASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESdate_defmt_asc</CODE
></DT
><DD
> Use a format mask to convert a C <TT
CLASS="TYPE"
>char*</TT
> string to a value of type
 date.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESdate_defmt_asc(date *d, char *fmt, char *str);</PRE
>
 
 The function receives a pointer to the date value that should hold the
 result of the operation (<TT
CLASS="LITERAL"
>d</TT
>), the format mask to use for
 parsing the date (<TT
CLASS="LITERAL"
>fmt</TT
>) and the C char* string containing
 the textual representation of the date (<TT
CLASS="LITERAL"
>str</TT
>). The textual
 representation is expected to match the format mask. However you do not
 need to have a 1:1 mapping of the string to the format mask. The
 function only analyzes the sequential order and looks for the literals
 <TT
CLASS="LITERAL"
>yy</TT
> or <TT
CLASS="LITERAL"
>yyyy</TT
> that indicate the
 position of the year, <TT
CLASS="LITERAL"
>mm</TT
> to indicate the position of
 the month and <TT
CLASS="LITERAL"
>dd</TT
> to indicate the position of the
 day.
 <A
HREF="ecpg-pgtypes.html#ECPG-RDEFMTDATE-EXAMPLE-TABLE"
>Table 33-4</A
> indicates a few possible formats. This will give
 you an idea of how to use this function.
 <DIV
CLASS="TABLE"
><A
NAME="ECPG-RDEFMTDATE-EXAMPLE-TABLE"
></A
>Table 33-4. Valid Input Formats for <CODE
CLASS="FUNCTION"
>rdefmtdate</CODE
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><COL><THEAD
><TR
><TH
>Format</TH
><TH
>String</TH
><TH
>Result</TH
></TR
></THEAD
><TBODY
><TR
><TD
><TT
CLASS="LITERAL"
>ddmmyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>21-2-54</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1954-02-21</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>ddmmyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>2-12-54</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1954-12-02</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>ddmmyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>20111954</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1954-11-20</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>ddmmyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>130464</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1964-04-13</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>mmm.dd.yyyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>MAR-12-1967</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1967-03-12</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>yy/mm/dd</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1954, February 3rd</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1954-02-03</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>mmm.dd.yyyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>041269</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1969-04-12</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>yy/mm/dd</TT
></TD
><TD
><TT
CLASS="LITERAL"
>In the year 2525, in the month of July, mankind will be alive on the 28th day</TT
></TD
><TD
><TT
CLASS="LITERAL"
>2525-07-28</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>dd-mm-yy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>I said on the 28th of July in the year 2525</TT
></TD
><TD
><TT
CLASS="LITERAL"
>2525-07-28</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>mmm.dd.yyyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>9/14/58</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1958-09-14</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>yy/mm/dd</TT
></TD
><TD
><TT
CLASS="LITERAL"
>47/03/29</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1947-03-29</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>mmm.dd.yyyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>oct 28 1975</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1975-10-28</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>mmddyy</TT
></TD
><TD
><TT
CLASS="LITERAL"
>Nov 14th, 1985</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1985-11-14</TT
></TD
></TR
></TBODY
></TABLE
></DIV
></DD
></DL
></DIV
>
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="ECPG-PGTYPES-TIMESTAMP"
>33.6.3. The timestamp Type</A
></H2
> The timestamp type in C enables your programs to deal with data of the SQL
 type timestamp. See <A
HREF="datatype-datetime.html"
>Section 8.5</A
> for the equivalent
 type in the PostgreSQL server.
 The following functions can be used to work with the timestamp type:
 <DIV
CLASS="VARIABLELIST"
><DL
><DT
><A
NAME="PGTYPESTIMESTAMPFROMASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_from_asc</CODE
></DT
><DD
> Parse a timestamp from its textual representation into a timestamp
 variable.
<PRE
CLASS="SYNOPSIS"
>timestamp PGTYPEStimestamp_from_asc(char *str, char **endptr);</PRE
>
 The function receives the string to parse (<TT
CLASS="LITERAL"
>str</TT
>) and a
 pointer to a C char* (<TT
CLASS="LITERAL"
>endptr</TT
>).
 At the moment ECPG always parses
 the complete string and so it currently does not support to store the
 address of the first invalid character in <TT
CLASS="LITERAL"
>*endptr</TT
>.
 You can safely set <TT
CLASS="LITERAL"
>endptr</TT
> to NULL.
 The function returns the parsed timestamp on success. On error,
 <TT
CLASS="LITERAL"
>PGTYPESInvalidTimestamp</TT
> is returned and <TT
CLASS="VARNAME"
>errno</TT
> is
 set to <TT
CLASS="LITERAL"
>PGTYPES_TS_BAD_TIMESTAMP</TT
>. See <A
HREF="ecpg-pgtypes.html#PGTYPESINVALIDTIMESTAMP"
><TT
CLASS="LITERAL"
>PGTYPESInvalidTimestamp</TT
></A
> for important notes on this value.
 In general, the input string can contain any combination of an allowed
 date specification, a whitespace character and an allowed time
 specification. Note that time zones are not supported by ECPG. It can
 parse them but does not apply any calculation as the
 PostgreSQL server does for example. Timezone
 specifiers are silently discarded.
 <A
HREF="ecpg-pgtypes.html#ECPG-PGTYPESTIMESTAMP-FROM-ASC-EXAMPLE-TABLE"
>Table 33-5</A
> contains a few examples for input strings.
 <DIV
CLASS="TABLE"
><A
NAME="ECPG-PGTYPESTIMESTAMP-FROM-ASC-EXAMPLE-TABLE"
></A
>Table 33-5. Valid Input Formats for <CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_from_asc</CODE
><TABLE
BORDER="1"
CLASS="CALSTABLE"
><COL><COL><THEAD
><TR
><TH
>Input</TH
><TH
>Result</TH
></TR
></THEAD
><TBODY
><TR
><TD
><TT
CLASS="LITERAL"
>1999-01-08 04:05:06</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1999-01-08 04:05:06</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>January 8 04:05:06 1999 PST</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1999-01-08 04:05:06</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>1999-Jan-08 04:05:06.789-8</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1999-01-08 04:05:06.789 (time zone specifier ignored)</TT
></TD
></TR
><TR
><TD
><TT
CLASS="LITERAL"
>J2451187 04:05-08:00</TT
></TD
><TD
><TT
CLASS="LITERAL"
>1999-01-08 04:05:00 (time zone specifier ignored)</TT
></TD
></TR
></TBODY
></TABLE
></DIV
></DD
><DT
><A
NAME="PGTYPESTIMESTAMPTOASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_to_asc</CODE
></DT
><DD
> Converts a date to a C char* string.
<PRE
CLASS="SYNOPSIS"
>char *PGTYPEStimestamp_to_asc(timestamp tstamp);</PRE
>
 The function receives the timestamp <TT
CLASS="LITERAL"
>tstamp</TT
> as
 its only argument and returns an allocated string that contains the
 textual representation of the timestamp.
 </DD
><DT
><A
NAME="PGTYPESTIMESTAMPCURRENT"
></A
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_current</CODE
></DT
><DD
> Retrieve the current timestamp.
<PRE
CLASS="SYNOPSIS"
>void PGTYPEStimestamp_current(timestamp *ts);</PRE
>
 The function retrieves the current timestamp and saves it into the
 timestamp variable that <TT
CLASS="LITERAL"
>ts</TT
> points to.
 </DD
><DT
><A
NAME="PGTYPESTIMESTAMPFMTASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_fmt_asc</CODE
></DT
><DD
> Convert a timestamp variable to a C char* using a format mask.
<PRE
CLASS="SYNOPSIS"
>int PGTYPEStimestamp_fmt_asc(timestamp *ts, char *output, int str_len, char *fmtstr);</PRE
>
 The function receives a pointer to the timestamp to convert as its
 first argument (<TT
CLASS="LITERAL"
>ts</TT
>), a pointer to the output buffer
 (<TT
CLASS="LITERAL"
>output</TT
>), the maximal length that has been allocated for
 the output buffer (<TT
CLASS="LITERAL"
>str_len</TT
>) and the format mask to
 use for the conversion (<TT
CLASS="LITERAL"
>fmtstr</TT
>).
 Upon success, the function returns 0 and a negative value if an
 error occurred.
 You can use the following format specifiers for the format mask. The
 format specifiers are the same ones that are used in the
 <CODE
CLASS="FUNCTION"
>strftime</CODE
> function in libc. Any
 non-format specifier will be copied into the output buffer.
 
 <UL
><LI
> <TT
CLASS="LITERAL"
>%A</TT
> - is replaced by national representation of
 the full weekday name.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%a</TT
> - is replaced by national representation of
 the abbreviated weekday name.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%B</TT
> - is replaced by national representation of
 the full month name.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%b</TT
> - is replaced by national representation of
 the abbreviated month name.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%C</TT
> - is replaced by (year / 100) as decimal
 number; single digits are preceded by a zero.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%c</TT
> - is replaced by national representation of
 time and date.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%D</TT
> - is equivalent to
 <TT
CLASS="LITERAL"
>%m/%d/%y</TT
>.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%d</TT
> - is replaced by the day of the month as a
 decimal number (01-31).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%E*</TT
> <TT
CLASS="LITERAL"
>%O*</TT
> - POSIX locale
 extensions. The sequences
 <TT
CLASS="LITERAL"
>%Ec</TT
>
 <TT
CLASS="LITERAL"
>%EC</TT
>
 <TT
CLASS="LITERAL"
>%Ex</TT
>
 <TT
CLASS="LITERAL"
>%EX</TT
>
 <TT
CLASS="LITERAL"
>%Ey</TT
>
 <TT
CLASS="LITERAL"
>%EY</TT
>
 <TT
CLASS="LITERAL"
>%Od</TT
>
 <TT
CLASS="LITERAL"
>%Oe</TT
>
 <TT
CLASS="LITERAL"
>%OH</TT
>
 <TT
CLASS="LITERAL"
>%OI</TT
>
 <TT
CLASS="LITERAL"
>%Om</TT
>
 <TT
CLASS="LITERAL"
>%OM</TT
>
 <TT
CLASS="LITERAL"
>%OS</TT
>
 <TT
CLASS="LITERAL"
>%Ou</TT
>
 <TT
CLASS="LITERAL"
>%OU</TT
>
 <TT
CLASS="LITERAL"
>%OV</TT
>
 <TT
CLASS="LITERAL"
>%Ow</TT
>
 <TT
CLASS="LITERAL"
>%OW</TT
>
 <TT
CLASS="LITERAL"
>%Oy</TT
>
 are supposed to provide alternative representations.
 Additionally <TT
CLASS="LITERAL"
>%OB</TT
> implemented to represent
 alternative months names (used standalone, without day mentioned).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%e</TT
> - is replaced by the day of month as a decimal
 number (1-31); single digits are preceded by a blank.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%F</TT
> - is equivalent to <TT
CLASS="LITERAL"
>%Y-%m-%d</TT
>.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%G</TT
> - is replaced by a year as a decimal number
 with century. This year is the one that contains the greater part of
 the week (Monday as the first day of the week).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%g</TT
> - is replaced by the same year as in
 <TT
CLASS="LITERAL"
>%G</TT
>, but as a decimal number without century
 (00-99).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%H</TT
> - is replaced by the hour (24-hour clock) as a
 decimal number (00-23).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%h</TT
> - the same as <TT
CLASS="LITERAL"
>%b</TT
>.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%I</TT
> - is replaced by the hour (12-hour clock) as a
 decimal number (01-12).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%j</TT
> - is replaced by the day of the year as a
 decimal number (001-366).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%k</TT
> - is replaced by the hour (24-hour clock) as a
 decimal number (0-23); single digits are preceded by a blank.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%l</TT
> - is replaced by the hour (12-hour clock) as a
 decimal number (1-12); single digits are preceded by a blank.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%M</TT
> - is replaced by the minute as a decimal
 number (00-59).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%m</TT
> - is replaced by the month as a decimal number
 (01-12).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%n</TT
> - is replaced by a newline.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%O*</TT
> - the same as <TT
CLASS="LITERAL"
>%E*</TT
>.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%p</TT
> - is replaced by national representation of
 either "ante meridiem" or "post meridiem" as appropriate.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%R</TT
> - is equivalent to <TT
CLASS="LITERAL"
>%H:%M</TT
>.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%r</TT
> - is equivalent to <TT
CLASS="LITERAL"
>%I:%M:%S
 %p</TT
>.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%S</TT
> - is replaced by the second as a decimal
 number (00-60).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%s</TT
> - is replaced by the number of seconds since
 the Epoch, UTC.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%T</TT
> - is equivalent to <TT
CLASS="LITERAL"
>%H:%M:%S</TT
>
 </LI
><LI
> <TT
CLASS="LITERAL"
>%t</TT
> - is replaced by a tab.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%U</TT
> - is replaced by the week number of the year
 (Sunday as the first day of the week) as a decimal number (00-53).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%u</TT
> - is replaced by the weekday (Monday as the
 first day of the week) as a decimal number (1-7).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%V</TT
> - is replaced by the week number of the year
 (Monday as the first day of the week) as a decimal number (01-53).
 If the week containing January 1 has four or more days in the new
 year, then it is week 1; otherwise it is the last week of the
 previous year, and the next week is week 1.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%v</TT
> - is equivalent to
 <TT
CLASS="LITERAL"
>%e-%b-%Y</TT
>.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%W</TT
> - is replaced by the week number of the year
 (Monday as the first day of the week) as a decimal number (00-53).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%w</TT
> - is replaced by the weekday (Sunday as the
 first day of the week) as a decimal number (0-6).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%X</TT
> - is replaced by national representation of
 the time.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%x</TT
> - is replaced by national representation of
 the date.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%Y</TT
> - is replaced by the year with century as a
 decimal number.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%y</TT
> - is replaced by the year without century as a
 decimal number (00-99).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%Z</TT
> - is replaced by the time zone name.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%z</TT
> - is replaced by the time zone offset from
 UTC; a leading plus sign stands for east of UTC, a minus sign for
 west of UTC, hours and minutes follow with two digits each and no
 delimiter between them (common form for RFC 822 date headers).
 </LI
><LI
> <TT
CLASS="LITERAL"
>%+</TT
> - is replaced by national representation of
 the date and time.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%-*</TT
> - GNU libc extension. Do not do any padding
 when performing numerical outputs.
 </LI
><LI
> $_* - GNU libc extension. Explicitly specify space for padding.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%0*</TT
> - GNU libc extension. Explicitly specify zero
 for padding.
 </LI
><LI
> <TT
CLASS="LITERAL"
>%%</TT
> - is replaced by <TT
CLASS="LITERAL"
>%</TT
>.
 </LI
></UL
>
 </DD
><DT
><A
NAME="PGTYPESTIMESTAMPSUB"
></A
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_sub</CODE
></DT
><DD
> Subtract one timestamp from another one and save the result in a
 variable of type interval.
<PRE
CLASS="SYNOPSIS"
>int PGTYPEStimestamp_sub(timestamp *ts1, timestamp *ts2, interval *iv);</PRE
>
 The function will subtract the timestamp variable that <TT
CLASS="LITERAL"
>ts2</TT
>
 points to from the timestamp variable that <TT
CLASS="LITERAL"
>ts1</TT
> points to
 and will store the result in the interval variable that <TT
CLASS="LITERAL"
>iv</TT
>
 points to.
 Upon success, the function returns 0 and a negative value if an
 error occurred.
 </DD
><DT
><A
NAME="PGTYPESTIMESTAMPDEFMTASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_defmt_asc</CODE
></DT
><DD
> Parse a timestamp value from its textual representation using a
 formatting mask.
<PRE
CLASS="SYNOPSIS"
>int PGTYPEStimestamp_defmt_asc(char *str, char *fmt, timestamp *d);</PRE
>
 The function receives the textual representation of a timestamp in the
 variable <TT
CLASS="LITERAL"
>str</TT
> as well as the formatting mask to use in the
 variable <TT
CLASS="LITERAL"
>fmt</TT
>. The result will be stored in the variable
 that <TT
CLASS="LITERAL"
>d</TT
> points to.
 If the formatting mask <TT
CLASS="LITERAL"
>fmt</TT
> is NULL, the function will fall
 back to the default formatting mask which is <TT
CLASS="LITERAL"
>%Y-%m-%d
 %H:%M:%S</TT
>.
 This is the reverse function to <A
HREF="ecpg-pgtypes.html#PGTYPESTIMESTAMPFMTASC"
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_fmt_asc</CODE
></A
>. See the documentation there in
 order to find out about the possible formatting mask entries.
 </DD
><DT
><A
NAME="PGTYPESTIMESTAMPADDINTERVAL"
></A
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_add_interval</CODE
></DT
><DD
> Add an interval variable to a timestamp variable.
<PRE
CLASS="SYNOPSIS"
>int PGTYPEStimestamp_add_interval(timestamp *tin, interval *span, timestamp *tout);</PRE
>
 The function receives a pointer to a timestamp variable <TT
CLASS="LITERAL"
>tin</TT
>
 and a pointer to an interval variable <TT
CLASS="LITERAL"
>span</TT
>. It adds the
 interval to the timestamp and saves the resulting timestamp in the
 variable that <TT
CLASS="LITERAL"
>tout</TT
> points to.
 Upon success, the function returns 0 and a negative value if an
 error occurred.
 </DD
><DT
><A
NAME="PGTYPESTIMESTAMPSUBINTERVAL"
></A
><CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_sub_interval</CODE
></DT
><DD
> Subtract an interval variable from a timestamp variable.
<PRE
CLASS="SYNOPSIS"
>int PGTYPEStimestamp_sub_interval(timestamp *tin, interval *span, timestamp *tout);</PRE
>
 The function subtracts the interval variable that <TT
CLASS="LITERAL"
>span</TT
>
 points to from the timestamp variable that <TT
CLASS="LITERAL"
>tin</TT
> points to
 and saves the result into the variable that <TT
CLASS="LITERAL"
>tout</TT
> points
 to.
 Upon success, the function returns 0 and a negative value if an
 error occurred.
 </DD
></DL
></DIV
>
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="ECPG-PGTYPES-INTERVAL"
>33.6.4. The interval Type</A
></H2
> The interval type in C enables your programs to deal with data of the SQL
 type interval. See <A
HREF="datatype-datetime.html"
>Section 8.5</A
> for the equivalent
 type in the PostgreSQL server.
 The following functions can be used to work with the interval type:
 <DIV
CLASS="VARIABLELIST"
><DL
><DT
><A
NAME="PGTYPESINTERVALNEW"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESinterval_new</CODE
></DT
><DD
> Return a pointer to a newly allocated interval variable.
<PRE
CLASS="SYNOPSIS"
>interval *PGTYPESinterval_new(void);</PRE
>
 </DD
><DT
><A
NAME="PGTYPESINTERVALFREE"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESinterval_free</CODE
></DT
><DD
> Release the memory of a previously allocated interval variable.
<PRE
CLASS="SYNOPSIS"
>void PGTYPESinterval_new(interval *intvl);</PRE
>
 </DD
><DT
><A
NAME="PGTYPESINTERVALFROMASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESinterval_from_asc</CODE
></DT
><DD
> Parse an interval from its textual representation.
<PRE
CLASS="SYNOPSIS"
>interval *PGTYPESinterval_from_asc(char *str, char **endptr);</PRE
>
 The function parses the input string <TT
CLASS="LITERAL"
>str</TT
> and returns a
 pointer to an allocated interval variable.
 At the moment ECPG always parses
 the complete string and so it currently does not support to store the
 address of the first invalid character in <TT
CLASS="LITERAL"
>*endptr</TT
>.
 You can safely set <TT
CLASS="LITERAL"
>endptr</TT
> to NULL.
 </DD
><DT
><A
NAME="PGTYPESINTERVALTOASC"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESinterval_to_asc</CODE
></DT
><DD
> Convert a variable of type interval to its textual representation.
<PRE
CLASS="SYNOPSIS"
>char *PGTYPESinterval_to_asc(interval *span);</PRE
>
 The function converts the interval variable that <TT
CLASS="LITERAL"
>span</TT
>
 points to into a C char*. The output looks like this example:
 <TT
CLASS="LITERAL"
>@ 1 day 12 hours 59 mins 10 secs</TT
>.
 </DD
><DT
><A
NAME="PGTYPESINTERVALCOPY"
></A
><CODE
CLASS="FUNCTION"
>PGTYPESinterval_copy</CODE
></DT
><DD
> Copy a variable of type interval.
<PRE
CLASS="SYNOPSIS"
>int PGTYPESinterval_copy(interval *intvlsrc, interval *intvldest);</PRE
>
 The function copies the interval variable that <TT
CLASS="LITERAL"
>intvlsrc</TT
>
 points to into the variable that <TT
CLASS="LITERAL"
>intvldest</TT
> points to. Note
 that you need to allocate the memory for the destination variable
 before.
 </DD
></DL
></DIV
>
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="ECPG-PGTYPES-DECIMAL"
>33.6.5. The decimal Type</A
></H2
> The decimal type is similar to the numeric type. However it is limited to
 a maximum precision of 30 significant digits. In contrast to the numeric
 type which can be created on the heap only, the decimal type can be
 created either on the stack or on the heap (by means of the functions
 <CODE
CLASS="FUNCTION"
>PGTYPESdecimal_new</CODE
> and
 <CODE
CLASS="FUNCTION"
>PGTYPESdecimal_free</CODE
>).
 There are a lot of other functions that deal with the decimal type in the
 Informix compatibility mode described in <A
HREF="ecpg-informix-compat.html"
>Section 33.15</A
>.
 The following functions can be used to work with the decimal type and are
 not only contained in the <TT
CLASS="LITERAL"
>libcompat</TT
> library.
 <DIV
CLASS="VARIABLELIST"
><DL
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESdecimal_new</CODE
></DT
><DD
> Request a pointer to a newly allocated decimal variable.
<PRE
CLASS="SYNOPSIS"
>decimal *PGTYPESdecimal_new(void);</PRE
>
 </DD
><DT
><CODE
CLASS="FUNCTION"
>PGTYPESdecimal_free</CODE
></DT
><DD
> Free a decimal type, release all of its memory.
<PRE
CLASS="SYNOPSIS"
>void PGTYPESdecimal_free(decimal *var);</PRE
>
 </DD
></DL
></DIV
>
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="ECPG-PGTYPES-ERRNO"
>33.6.6. errno Values of pgtypeslib</A
></H2
> <DIV
CLASS="VARIABLELIST"
><DL
><DT
><TT
CLASS="LITERAL"
>PGTYPES_NUM_BAD_NUMERIC</TT
></DT
><DD
> An argument should contain a numeric variable (or point to a numeric
 variable) but in fact its in-memory representation was invalid.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_NUM_OVERFLOW</TT
></DT
><DD
> An overflow occurred. Since the numeric type can deal with almost
 arbitrary precision, converting a numeric variable into other types
 might cause overflow.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_NUM_UNDERFLOW</TT
></DT
><DD
> An underflow occurred. Since the numeric type can deal with almost
 arbitrary precision, converting a numeric variable into other types
 might cause underflow.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_NUM_DIVIDE_ZERO</TT
></DT
><DD
> A division by zero has been attempted.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_DATE_BAD_DATE</TT
></DT
><DD
> An invalid date string was passed to
 the <CODE
CLASS="FUNCTION"
>PGTYPESdate_from_asc</CODE
> function.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_DATE_ERR_EARGS</TT
></DT
><DD
> Invalid arguments were passed to the
 <CODE
CLASS="FUNCTION"
>PGTYPESdate_defmt_asc</CODE
> function.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_DATE_ERR_ENOSHORTDATE</TT
></DT
><DD
> An invalid token in the input string was found by the
 <CODE
CLASS="FUNCTION"
>PGTYPESdate_defmt_asc</CODE
> function.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_INTVL_BAD_INTERVAL</TT
></DT
><DD
> An invalid interval string was passed to the
 <CODE
CLASS="FUNCTION"
>PGTYPESinterval_from_asc</CODE
> function, or an
 invalid interval value was passed to the
 <CODE
CLASS="FUNCTION"
>PGTYPESinterval_to_asc</CODE
> function.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_DATE_ERR_ENOTDMY</TT
></DT
><DD
> There was a mismatch in the day/month/year assignment in the
 <CODE
CLASS="FUNCTION"
>PGTYPESdate_defmt_asc</CODE
> function.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_DATE_BAD_DAY</TT
></DT
><DD
> An invalid day of the month value was found by
 the <CODE
CLASS="FUNCTION"
>PGTYPESdate_defmt_asc</CODE
> function.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_DATE_BAD_MONTH</TT
></DT
><DD
> An invalid month value was found by
 the <CODE
CLASS="FUNCTION"
>PGTYPESdate_defmt_asc</CODE
> function.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_TS_BAD_TIMESTAMP</TT
></DT
><DD
> An invalid timestamp string pass passed to
 the <CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_from_asc</CODE
> function,
 or an invalid timestamp value was passed to
 the <CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_to_asc</CODE
> function.
 </DD
><DT
><TT
CLASS="LITERAL"
>PGTYPES_TS_ERR_EINFTIME</TT
></DT
><DD
> An infinite timestamp value was encountered in a context that
 cannot handle it.
 </DD
></DL
></DIV
>
 </DIV
><DIV
CLASS="SECT2"
><H2
CLASS="SECT2"
><A
NAME="ECPG-PGTYPES-CONSTANTS"
>33.6.7. Special Constants of pgtypeslib</A
></H2
> <DIV
CLASS="VARIABLELIST"
><DL
><DT
><A
NAME="PGTYPESINVALIDTIMESTAMP"
></A
><TT
CLASS="LITERAL"
>PGTYPESInvalidTimestamp</TT
></DT
><DD
> A value of type timestamp representing an invalid time stamp. This is
 returned by the function <CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_from_asc</CODE
> on
 parse error.
 Note that due to the internal representation of the <TT
CLASS="TYPE"
>timestamp</TT
> data type,
 <TT
CLASS="LITERAL"
>PGTYPESInvalidTimestamp</TT
> is also a valid timestamp at
 the same time. It is set to <TT
CLASS="LITERAL"
>1899-12-31 23:59:59</TT
>. In order
 to detect errors, make sure that your application does not only test
 for <TT
CLASS="LITERAL"
>PGTYPESInvalidTimestamp</TT
> but also for
 <TT
CLASS="LITERAL"
>errno != 0</TT
> after each call to
 <CODE
CLASS="FUNCTION"
>PGTYPEStimestamp_from_asc</CODE
>.
 </DD
></DL
></DIV
>
 </DIV
></DIV
><DIV
CLASS="NAVFOOTER"
><HR
ALIGN="LEFT"
WIDTH="100%"><TABLE
SUMMARY="Footer navigation table"
WIDTH="100%"
BORDER="0"
CELLPADDING="0"
CELLSPACING="0"
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
><A
HREF="ecpg-dynamic.html"
ACCESSKEY="P"
>Prev</A
></TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="index.html"
ACCESSKEY="H"
>Home</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
><A
HREF="ecpg-descriptors.html"
ACCESSKEY="N"
>Next</A
></TD
></TR
><TR
><TD
WIDTH="33%"
ALIGN="left"
VALIGN="top"
>Dynamic SQL</TD
><TD
WIDTH="34%"
ALIGN="center"
VALIGN="top"
><A
HREF="ecpg.html"
ACCESSKEY="U"
>Up</A
></TD
><TD
WIDTH="33%"
ALIGN="right"
VALIGN="top"
>Using Descriptor Areas</TD
></TR
></TABLE
></DIV
></BODY
></HTML
>

${this.title}

Code Editor : ecpg-pgtypes.html