substring problem
| От | Sh A Guru Prasad |
|---|---|
| Тема | substring problem |
| Дата | |
| Msg-id | 200312311000.hBVA0RmB021397@apsu.ap.nic.in обсуждение исходный текст |
| Ответы |
Re: substring problem
Re: substring problem |
| Список | pgsql-bugs |
select trn_id,substr(hoa_id,1,13) from tbill_master where
substr(hoa
_id,1,13)='2202031040006';
trn_id | substr
----------------+---------------
25001203000416 | 2202031040006
25001203000417 | 2202031040006
25001203000418 | 2202031040006
25001203000419 | 2202031040006
25001203000420 | 2202031040006
25001203000421 | 2202031040006
25001203000422 | 2202031040006
25001203000536 | 2202031040006
and
select trn_id,substr(hoa_id,0,14) from tbill_master where
substr(hoa
_id,0,14)='2202031040006';
trn_id | substr
----------------+---------------
25001203000416 | 2202031040006
25001203000417 | 2202031040006
25001203000418 | 2202031040006
25001203000419 | 2202031040006
25001203000420 | 2202031040006
25001203000421 | 2202031040006
25001203000422 | 2202031040006
25001203000536 | 2202031040006
both give the same result how? Is it query problem or
postgress substring problem please clarify.
В списке pgsql-bugs по дате отправления: