[teiid-issues] [JBoss JIRA] Closed: (TEIID-758) Add locate function support to postgres

Add locate function support to postgres --------------------------------------- Key: TEIID-758 URL: https://jira.jboss.org/browse/TEIID-758 Project: Teiid Issue Type: Feature Request Components: JDBC Connector Affects Versions: 6.2.0 Reporter: Steven Hawkins Assignee: Steven Hawkins Priority: Optional Fix For: 6.2.0 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.