| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Moritz Sinn <moritz(at)freesources(dot)org> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: datatype: not variable, not fixed length |
| Date: | 2002-08-26 20:07:14 |
| Message-ID: | 200208262007.g7QK7Ee18849@candle.pha.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Well variable is defined at creation time, see char() and varchar().
text data type is truely variable. pg_attribute.atttypmod has info
about the lenght.
---------------------------------------------------------------------------
Moritz Sinn wrote:
>
> hi,
>
> i'd like to write a datatype which is similar to varchar, i want the
> programmer be able to set its length when he creates the table. but
> it seems that there are only 2 options: completely variable or fixed.
> so do i have to write an new basic type and recompile postgresql?
>
> thanks,
> moritz
>
> --
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org
>
--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Warren Massengill | 2002-08-26 20:20:10 | Re: RES: postgreSQL-7.2.2 install problem |
| Previous Message | Moritz Sinn | 2002-08-26 20:03:50 | datatype: not variable, not fixed length |