From: Fatih Cerit <fatih@intersan.com.tr>
To: pgsql-sql@postgresql.org
Subject: substr or char_length problem
Date: Fri, 17 Jun 2005 13:01:15 +0300
Message-ID: <014a01c57323$90b72b20$b8e58bd5@cerit> (raw)
Dear ALL
I have a problem with function substr or char_length or both. I guery A2 and
it works fine. But sometimes gives 'ERROR: negative substring length not
allowed'. When I test many many times with diffrent values, never gives
error. Sample table and query below.
A1 A2
-------------------
1 1957
2 197
3 19
4
5 NULL
6 1
7 195
Select * from tbl_xxx where
tbl_xxx.A2=substr('196895588454554545454',0,char_length(tbl_xxx.A2)+1);
Thanks
Fatih Cerit
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: fatih@intersan.com.tr
Subject: Re: substr or char_length problem
In-Reply-To: <014a01c57323$90b72b20$b8e58bd5@cerit>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox