Re: [BUGS] substring problem

Hi, Sh A Guru Prasad wrote, On 12/31/2003 11:00 AM: 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 | 2202

Re: [BUGS] substring problem

Sh A Guru Prasad <[EMAIL PROTECTED]> writes: > [ substr(x,1,13) is the same as substr(x,0,14) ] This is not a bug, this is per SQL99 spec. regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[BUGS] substring problem

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 250012030