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
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
The following bug has been logged online:
Bug reference: 1039
Logged by: prakash
Email address: [EMAIL PROTECTED]
PostgreSQL version: 7.5 Dev
Operating system: linux
Description:programm compilation
Details:
A programm compiled with invalid outputs.
-
