5 ms·
Their statement is somewhat ambiguous. They may have tried to express that "you can't add a column of the TEXT class without specifying the exact type". So the
by pizza234 7y ago
Their statement is somewhat ambiguous. They may have tried to express that "you can't add a column of the TEXT class without specifying the exact type".
So they could be "right", but expressed the concept in an imprecise form.
In a way, I think this shows their lack of expertise with MySQL - I reckon that somebody with a long experience would have phrased the concept more precisely.
- striking 7y agoIt doesn't matter, because they're looking for a different thing entirely. PostgreSQL TEXT is just without a limit. Simple as that.
- sbov 7y agoNot true, from: https://www.postgresql.org/docs/current/datatype-character.html https://www.postgresql.org/docs/current/datatype-character.h... > In any case, the longest possible character string that can be stored is about 1 GB.
- michelpp 7y agoTEXT, like all Postgres varlena types, is limited to 1GB. Which for many people is effectively without limit.