Tracking: Basic Built-in Functions

[TennyZhuang]

Reference: PostgreSQL: Documentation: 14: Chapter 9. Functions and Operators

General for all types

• TEXT format input / output (cast from / into string)
• BINARY format input / output
• singularity-data/risingwave-legacy#1916
• singularity-data/risingwave-legacy#667
• Implement coalesce function #2284

Aggregate

• count

Equality and Ordering for "most" types

• = / <> / !=
• Implement IS (NOT) DISTINCT FROM` functions #2684
• Implement nullif function #2283
• singularity-data/risingwave-legacy#666
• < / <= / > / >=
• Implement (NOT) BETWEEN AND functions
• greatest least function  #12761

Aggregate

• min / max

Boolean

• explicit cast from / into int
• Implement AND/OR/NOT operators
• IS [NOT] [TRUE | FALSE]
• support IS [NOT] UNKNOWN #8933

Aggregate

• Support aggregate every / bool_and / bool_or #8936

Window functions

• Tracking: window functions and window aggregation #8961

Misc

• Dummy pg_catalog.age(xid) expression #14118

More

• Tracking: mathematical functions #8806
• Tracking: string and bytea functions #8831
• Tracking: date/time functions #8849
• Tracking: array functions & operators #7117
• Tracking: jsonb operations #7714

[rotten]

I just ran into an issue with a tool that needed to run pg_try_advisory_lock, which, of course, failed because that function doesn't exist yet. I don't see it in the list of functions (above) in this ticket already, so I thought I'd toss a vote in to add at least a mock for the function if the actual implementation doesn't make sense. https://www.postgresql.org/docs/15/functions-admin.html#FUNCTIONS-ADVISORY-LOCKS-TABLE

[rotten]

The tool I was trying to use is sqitch . It uses advisory locks to ensure that only one sqitch is running at a time.

[neverchanje]

Thanks. @rotten We'll do some testing with sqitch and see if there are other lacking features.

[rotten]

Awesome! Thanks!