By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,372 Members | 1,950 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,372 IT Pros & Developers. It's quick & easy.

why isn't TEXT a key word?

P: n/a
I wrote a little vim script that converts the case of postgresql
keywords to uppercase and I noticed that TEXT was not being hit. Sure
enough TEXT is not listed as a key word in the sql key word appendix. I
thought it was strange that TEXT, a data type, is not a key word.

culley

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
culley harrelson <cu****@fastmail.fm> writes:
I thought it was strange that TEXT, a data type, is not a key word.


Why would you think that? Given that Postgres has an extensible type
system, we'd hardly want type names to be keywords. They're just
identifiers.

We do have keywords for some types that are mandated to have special
syntax by the SQL spec, such as "character varying(n)", because they
need special processing in the grammar.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ma*******@postgresql.org so that your
message can get through to the mailing list cleanly

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.