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.
Дата
Msg-id 4DC277AB.6090206@faresoftware.it
обсуждение исходный текст
Ответ на Re: How to obtain the max length of a varchar(50) field.  (Andreas Kretschmer <akretschmer@spamfence.net>)
Список pgsql-novice
On 05/05/2011 11:03, Andreas Kretschmer wrote:
> Mauro Ziliani<mauro@faresoftware.it>  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
Дата:
Сообщение: Re: How to obtain the max length of a varchar(50) field.
Следующее
От: Grzegorz Szpetkowski
Дата:
Сообщение: Re: Looking for table in PostregSQL that contains Operating System and Processor information