| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | mike <matrix(at)quadrent(dot)net> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: name vs text vs varchar |
| Date: | 2001-03-05 17:16:41 |
| Message-ID: | 200103051716.MAA12488@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
[ Charset ISO-8859-1 unsupported, converting... ]
> reading through the curent development docs, I've run accross
> a data type called "name", and it looks very similar to varchar
> or text, and I'm wondering if there is any atvantage to useing
> this data type over varchar or even text?
It is used for system catalogs. No reason for users to use it. It is
fixed length 31 or NAMEDATALEN-1, and has no 4-byte length header like
the other text/varchar/char types.
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Limin Liu | 2001-03-05 17:22:07 | chinese_big5 for PgAccess |
| Previous Message | Patrik Kudo | 2001-03-05 16:55:41 | avg() bug? |