I have an select statement inherited from an Informix-4GL application. I
would like to know if there is a way to retain it in Postgresql:
select count(*) from people where peopcode[1,2] = a_var
This sort of subscripting is apparently illegal. I realize I can change the
code to " ...peopcode like a_var + "%"", but to do this I would need to make a
number of other code changes I'd like to avoid if possible.
Thanks, Scott