Getting lengths of variable fields

Поиск
Список
Период
Сортировка
От Michelle Murrain
Тема Getting lengths of variable fields
Дата
Msg-id 0103051644530B.13048@chicago.murrain.net
обсуждение исходный текст
Ответы Re: Getting lengths of variable fields
Список pgsql-general
Hi folks,

I'm writing a very robust validation script in perl for database entry. One
of the things I'd like to do is check how large a field is, and make sure
that the entry into that field isn't too big. Problem is, for variable length
fields, DBD::Pg returns a -1 size, using the pg_size attribute.

Is there something I am missing? Is there a way to get the size of variable
length types using DBI/DBD::Pg, in particular, char() and varchar()?

Michelle
--
------------
Michelle Murrain, Ph.D.
President
Norwottuck Technology Resources
mpm@norwottuck.com
http://www.norwottuck.com

В списке pgsql-general по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: multiple dbs on a port
Следующее
От: Kyle
Дата:
Сообщение: function overloading / ambigous functions