6 ms·
"very limited datatypes"? You haven't used Postgres very much, have you? http://www.postgresql.org/docs/9.2/static/datatype.html http://www.postgresql.org/docs/
by anthonyb 13y ago
"very limited datatypes"? You haven't used Postgres very much, have you? http://www.postgresql.org/docs/9.2/static/datatype.html http://www.postgresql.org/docs/9.2/static/datatype.html
And those are just the built-in ones, not counting PostGIS and other ones that you can define: http://www.postgresql.org/docs/9.1/static/extend-type-system.html http://www.postgresql.org/docs/9.1/static/extend-type-system...
- lmm 13y agoThey're very limited compared to what you'd get in a real programming language. The fact that the language needs to define types for so many things is actually a demonstration of this - the reason postgres has built-in types for things like IP addresses or line segments is because it's too hard for users to implement such things themselves and very little notion of library code.
- anthonyb 13y agoAgain, you haven't used Postgres very much if you think that. IP addresses are in there because they are generally useful, not because they're hard to implement. Go have a look at the complex number implementation here: http://www.postgresql.org/docs/9.1/static/xtypes.html http://www.postgresql.org/docs/9.1/static/xtypes.html then come back and tell me that Postgres is "not a real programming language" (whatever that means these days).