Changes between Initial Version and Version 2 of Ticket #33905


Ignore:
Timestamp:
Aug 8, 2022, 12:59:38 AM (2 years ago)
Author:
David Sanders
Comment:

Legend:

Unmodified
Added
Removed
Modified
  • Ticket #33905

    • Property Has patch set
  • Ticket #33905 – Description

    initial v2  
    2929This is because Postgres' lower() and upper() functions are overloaded to accept either text or range types - the former for converting case with the latter retrieving the lower/upper bounds of the range.
    3030
    31 When an expression LOWER(NULL) is encountered Postgres assumes the resulting expression is text:
     31When an expression LOWER(NULL) is encountered without an underlying column Postgres assumes the resulting expression is text:
    3232
    3333{{{
Back to Top