Hello,
How should I do my query to put a substring value in a field, in
postgres ( I have 6.4) ?
I have in table table_a
a
----------------
98-004_c136
P124_154
98-005_c171
and i want to select only the text before the underscore:
in sybase, this should be
select a, substring(a,1,charindex('_',a)-1) from table_a
a
---------------- ----------------
98-004_c136 98-004
98-005_c171 98-005
P124_154 P124
Thanks a lot,
Nuch