Postgres Pro
Downloads
Home   >   mailing lists

substring problem - Mailing list pgsql-bugs

From Sh A Guru Prasad
Subject substring problem
Date
Msg-id 200312311000.hBVA0RmB021397@apsu.ap.nic.in
Whole thread Raw
Responses Re: substring problem  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: substring problem  (CoL <col@mportal.hu>)
List pgsql-bugs
Tree view 
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 by date:

Previous
From: "PostgreSQL Bugs List"
Date:
Subject: BUG #1039: programm compilation
Next
From: Tom Lane
Date:
Subject: Re: substring problem