Re: How to obtain the max length of a varchar(50) field.

Поиск
Список
Период
Сортировка
Искать
От
Mauro Ziliani
Тема
Re: How to obtain the max length of a varchar(50) field.
Дата
в 07:11:14
Msg-id
4DC277AB.6090206@faresoftware.it
Ответ на
Список
Дерево обсуждения
How to obtain the max length of a varchar(50) field. Mauro Ziliani <mauro@faresoftware.it>
Re: How to obtain the max length of a varchar(50) field. Andreas Kretschmer <akretschmer@spamfence.net>
Re: How to obtain the max length of a varchar(50) field. Mauro Ziliani <mauro@faresoftware.it>
Re: How to obtain the max length of a varchar(50) field. Simon Riggs <simon@2ndQuadrant.com>
Re: How to obtain the max length of a varchar(50) field. Mauro Ziliani <mauro@faresoftware.it>
On 05/05/2011 11:03, Andreas Kretschmer wrote:
> Mauro Ziliani  wrote:
>
>> Hi all.
>> I'm working with Postgres 9.0 and wxWidgets.
>> I need to query the db about a field of a table.
>>
>> The table T has a field varchar(50).
>>
>> table: TAB0
>> customer: varchar(50)
>>
>> How can I get the max size of the field?
> select max(length(customer)) from tab0;
>
>
>
> Andreas
Thank you for the suggestion.
But I look a C function which access PGresult record.

This is usefull for an sql script.
Thank you very much.

MZ


В списке pgsql-novice по дате отправления
От: Mauro Ziliani
Дата:
От: Grzegorz Szpetkowski
Дата:
FAQ