PostgreSQL versions: 7.4.x and 8.0.x
(I don't have a 8.1.x installation to test against)
 
There appears to be no length checking for data types of "name".
 
For example:
template1=# SELECT length('rpt_cisx_total_principal_amount_of_security_type_between_dates('::name) AS name_len;
 name_len
----------
       63
(1 row)
 
I get exactly the same result for this query which is obviously not the same length and yet I get no error?
 
template1=# SELECT length('rpt_cisx_total_principal_amount_of_security_type_between_dates(date,date)'::name) AS name_len;
 name_len
----------
       63
(1 row)
I don't know whether you consider this a bug, certainly most of the other data types appear to have range checking as part of the input.
 
Regards
Donald Fraser

Reply via email to