Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-758

Add locate function support to postgres

XMLWordPrintable

    • Icon: Feature Request Feature Request
    • Resolution: Done
    • Icon: Optional Optional
    • 6.2.0
    • 6.2.0
    • JDBC Connector
    • None
    • Release Notes
    • Low

      Add support for locate to the postgresql translator. The 2 arg form is trival, but just as their jdbc escape docs indicate the 3 arg version needs more effort. For our purposes we'll use position('sub' in substr('string', fromIndex)).

      See TEIID-754 for possibly adding logic on the from index to ensure consistency with values less than 1.

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: