Wiki / Operators / Character strings
^@(text,text)
starts with
Reading PostgreSQL 18.6.
Description
starts with
- Left operand
- text
- Right operand
- text
- Result type
- bool
- Implementing function
- starts_with(text,text)
- Operator kind
- Binary
- Hash join candidate
- no
- Merge join candidate
- no
Usage
^@(text,text) → boolEnglish manual definition
Returns true if the first string starts with the second string (equivalent to the starts_with() function).
'alphabet' ^@ 'alph' → t
Catalog interpretation
The catalog pg_operator stores information about operators. See CREATE OPERATOR and Section 36.14 for more information.
Declared operator-family membership
Related entries
Documentation and source
- Matching PostgreSQL source archive
- PostgreSQL 18 English manual: catalog-pg-operator.html
- PostgreSQL 18 English manual: catalog-pg-amop.html
- PostgreSQL 18 English manual: functions-string.html
Source build
- Version
- 18.6
- Build
- https://ftp.postgresql.org/pub/source/v18.6/postgresql-18.6.tar.bz2
- Source fingerprint
555610c24d53e4316da5b7d3fc25c279d96856d5e0e23ee308c328c5fa881d9f
Compare versions
PostgreSQL 10 → 11: added.
--- PostgreSQL 10
+++ PostgreSQL 11
@@ -1 +1,26 @@
-Not recorded in this version
+{
+ "memberships": [
+ {
+ "family": "text_ops",
+ "left_type": "text",
+ "method": "spgist",
+ "operator": "^@(text,text)",
+ "purpose": "search",
+ "right_type": "text",
+ "sort_family": "",
+ "strategy": "28"
+ }
+ ],
+ "operator": {
+ "commutator": "",
+ "function": "starts_with(text,text)",
+ "hash_join": "f",
+ "kind": "b",
+ "left_type": "text",
+ "merge_join": "f",
+ "negator": "",
+ "result_type": "bool",
+ "right_type": "text",
+ "symbol": "^@"
+ }
+}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
Export JSON · Back to Operators · Recorded in PostgreSQL 11 through 20; the first sample is not necessarily its introduction.