Subscripts in select statements - Mailing list pgsql-general

From Scott Holmes
Subject Subscripts in select statements
Date
Msg-id 200007250018.RAA11633@scotts.mynetwork.net
Whole thread Raw
List pgsql-general
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


pgsql-general by date:

Previous
From: Chris Bitmead
Date:
Subject: Re: ROLLBACK automatically
Next
From: Tom Lane
Date:
Subject: Re: Statistical Analysis