| From: | <fmiddleton(at)verizon(dot)net> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | can UNIQUEness of TEXT datatype really be guaranteed? |
| Date: | 2005-11-22 17:35:00 |
| Message-ID: | 2238206.1132680900217.JavaMail.root@vms068.mailsrvcs.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
I am in the process re-implementing some pgsql table declarations into a MySQL database. I have this one line where I say
...
fieldname TEXT UNIQUE,
...
in my pgsql table because I want to ensure that no one enters the same thing in this field and I didn't choose VARCHAR type because I have no idea how possibly long I might need to let the field be...
... but MySQL doesn't like this because a TEXT datatype is considered a BLOB that can't be indexed and it can't guarantee will be UNIQUE apparently...
So I can't help but wonder, can Postgres really guarantee a TEXT field to be UNIQUE... or is declaring a TEXT field UNIQUE something an uninformed, novice user would do?... or is it something indicative of the strength and/or weeknesses that separate the functionality of the two DBMSs.
Ferindo Middleton
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jaime Casanova | 2005-11-22 17:45:36 | Re: can UNIQUEness of TEXT datatype really be guaranteed? |
| Previous Message | Leif B. Kristensen | 2005-11-22 17:17:23 | Re: Triggers |