varchar[] or text[]
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, ....?
This was discussed yesterday and previously. Please read the archives.
There is no positive performance reason to use varchar instead of text.
On 2010-07-22 05:38:14PM +0200, Armand Turpel wrote:
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, ....?--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
--
===========================================================
Peter C. Lai | Bard College at Simon's Rock
Systems Administrator | 84 Alford Rd.
Information Technology Svcs. | Gt. Barrington, MA 01230 USA
peter AT simons-rock.edu | (413) 528-7428
===========================================================
Import Notes
Reply to msg id not found: 21830_1279822575_4C488AEE_21830_36_1_4C4865E6.7070109@mnhn.luReference msg id not found: 21830_1279822575_4C488AEE_21830_36_1_4C4865E6.7070109@mnhn.lu | Resolved by subject fallback