=(date,timestamp)

Description

equal

Left operand

date

Right operand

timestamp

Result type

bool

Implementing function

date_eq_timestamp(date,timestamp)

Operator kind

Binary

Hash join candidate

no

Merge join candidate

yes

Usage

=(date,timestamp) → bool

Catalog interpretation

The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.

Related entries

• date data type
• timestamp data type
• bool data type
• Commutator: =(timestamp,date)
• Negator: <>(date,timestamp)
• btree/datetime_ops family
• brin/datetime_minmax_ops family
• brin/datetime_minmax_multi_ops family

Documentation and source

• Matching PostgreSQL source archive
• PostgreSQL 18 English manual: catalog-pg-operator.html
• PostgreSQL 18 English manual: catalog-pg-amop.html

Compare versions

PostgreSQL 13 → 14: changed.

--- PostgreSQL 13
+++ PostgreSQL 14
@@ -1,5 +1,15 @@
 {
   "memberships": [
+    {
+      "family": "datetime_minmax_multi_ops",
+      "left_type": "date",
+      "method": "brin",
+      "operator": "=(date,timestamp)",
+      "purpose": "search",
+      "right_type": "timestamp",
+      "sort_family": "",
+      "strategy": "3"
+    },
     {
       "family": "datetime_minmax_ops",
       "left_type": "date",

Compares recorded interfaces and attributes. Source fingerprints and build metadata are excluded; an absent sample is not proof of the introduction or removal release.

Related entries

• *(interval,float8)
• +(date,int4)
• +(date,interval)
• +(date,time)
• +(date,timetz)
• +(interval,date)
• +(interval,interval)
• +(interval,time)
• +(interval,timestamp)
• +(interval,timestamptz)
• +(interval,timetz)
• +(time,date)