| From: | Sh A Guru Prasad <guru(at)ap(dot)nic(dot)in> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | substring problem |
| Date: | 2003-12-31 10:00:27 |
| Message-ID: | 200312311000.hBVA0RmB021397@apsu.ap.nic.in |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CoL | 2003-12-31 15:43:54 | Re: substring problem |
| Previous Message | PostgreSQL Bugs List | 2003-12-31 07:11:17 | BUG #1039: programm compilation |