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
|
- [BUGS] No length checking for "name" input Donald Fraser