| F.22. fulleq | ||||
|---|---|---|---|---|
| Prev | Up | Appendix F. Additional Supplied Modules and Extensions Shipped inpostgrespro-std-15-contrib | Home | Next |
F.22. fulleq
Thefulleq module provides additional equivalence operator for compatibility with Microsoft SQL Server.
This module is required for 1C Enterprise support.
F.22.1. Overview
ThePostgres Pro equivalence operator is defined to return NULL when both operands are NULLs. However, the Microsoft SQL Servers family traditionally defines other semantic for equivalence operator, where operator returns TRUE in the case of both nulled operands. This module provides such operator with MS SQL semantic.
F.22.2. Operator fulleq
The== operator is defined for the following data types:
bool
bytea
char
name
int2
int4
int8
int2vector
text
oid
xid
cid
oidvector
float4
float8
abstime
reltime
macaddr
inet
cidr
varchar
date
time
timestamp
timestamptz
interval
timetz
F.22.3. Authors
Teodor Sigaev <teodor@sigaev.ru>