Thread: varchar[] !?

Hi

When I try to create a new column with the varchar datatype I obtain a 
"varchar[]" type, and I cannot specify the max limit.  What is the problem?

I am using:
psql (PostgreSQL) 7.4.2
pgadmin 1.0.2
Debian (unstable) Linux 2.4.18
-- 
Pedro Henrique e Figueiredo Quaresma de Almeida

Em Segunda, 10 de Maio de 2004 18:06, escreveste:
> Hi
>
> When I try to create a new column with the varchar datatype I obtain a
> "varchar[]" type, and I cannot specify the max limit.  What is the problem?
>
> I am using:
> psql (PostgreSQL) 7.4.2
> pgadmin 1.0.2
> Debian (unstable) Linux 2.4.18

My mistake, there are two different types "varchar" and "varchar[]". I want
one and I was using the other.

-- 
Pedro Henrique e Figueiredo Quaresma de Almeida

> When I try to create a new column with the varchar datatype I obtain a 
> "varchar[]" type, and I cannot specify the max limit.  What is the problem?

You are going VARCHAR[n] instead of the correct VARCHAR(n)

Chris

Em Terça, 11 de Maio de 2004 01:08, escreveste:
> > When I try to create a new column with the varchar datatype I obtain a
> > "varchar[]" type, and I cannot specify the max limit.  What is the
> > problem?
>
> You are going VARCHAR[n] instead of the correct VARCHAR(n)
>
> Chris

Yes, but when I try to choose the type in the types-menu the options that I
have are all with square brackets "[]" and not with "()"

--
Pedro Henrique e Figueiredo Quaresma de Almeida

Pedro Quaresma de Almeida wrote:

>Em Terça, 11 de Maio de 2004 01:08, escreveste:
>  
>
>>>When I try to create a new column with the varchar datatype I obtain a
>>>"varchar[]" type, and I cannot specify the max limit.  What is the
>>>problem?
>>>      
>>>
>>You are going VARCHAR[n] instead of the correct VARCHAR(n)
>>
>>Chris
>>    
>>
>
>Yes, but when I try to choose the type in the types-menu the options that I 
>have are all with square brackets "[]" and not with "()"
>
>  
>
Use varchar (varchar[] is the array version) and fill the length field.

Regards,
Andreas