varchar[] or text[]

From: Armand Turpel <armand(dot)turpel(at)googlemail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: varchar[] or text[]
Date: 2010-07-22 15:38:14
Message-ID: 4C4865E6.7070109@mnhn.lu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I know this issue was controversed discussed. Some one see no really
benefits of using varchar against text var. But i'm asking me what if i
use it as array values. Is there any difference between varchar[126],
varchar[10000] and text[] else than the number of chars i can store in?
Performance, memory usage, ....?

Browse pgsql-general by date

  From Date Subject
Next Message Andrus 2010-07-22 15:58:24 Re: How to distribute quantity if same product is in multiple rows
Previous Message Ben Chobot 2010-07-22 14:48:43 Re: Getting statistics for each sql statement?