For what it's worth Ingres (now Actian Ingres, I think) follows PostgreSQL and MySQL - both SUBSTR and SUBSTRING are supported. When I worked with and for Ingres we were stuck with LEFT and RIGHT so a substring got a little messy.
For what it's worth Ingres (now Actian Ingres, I think) follows PostgreSQL and MySQL - both SUBSTR and SUBSTRING are supported. When I worked with and for Ingres we were stuck with LEFT and RIGHT so a substring got a little messy.