Re: text field

Raphael,

> I need to put a field in a database that will hold a login for the
>  users.
> That login is rather long (it's their e-mail address) and of variable
>  length (I can't
> change that :-).
> I thought of using the text type, but wondered what were the
>  implications in terms of
> speed and amount of data (does it use much more space than other
>  character types?)

Not in PostgreSQL.  However, you may find that some interfaces (such as
 ODBC and JDBC) put limits on waht you can do with a Text column.  For
 example, MS Access/ODBC will interpret a TEXT field (or and VARCHAR
 over 250 chars) as a "memo" field and refuse to let you search or
 aggregate on the field.

Otherwise, TEXT and VARCHAR perform the same in PostgreSQL.

-Josh Berkus

______AGLIO DATABASE SOLUTIONS___________________________
                                       Josh Berkus
  Complete information technology      josh@agliodbs.com
   and data management solutions       (415) 565-7293
  for law firms, small businesses        fax 621-2533
    and non-profit organizations.      San Francisco