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 beselect a, substring(a,1,charindex('_',a)-1) from table_aa----------------
----------------98-004_c136 98-00498-005_c171 98-005P124_154 P124
Thanks a lot, Nuch