ANSI SQL keywords in RT schema

RT Developers
1

Hello.
I want note that RT uses some keywords in its schema.
For example Type. It’s not fully reserved word, in SQL’92 noted that
this word in list of candidates on inclusion.

			Best regards. Ruslan.
2 
  Hello.

I want note that RT uses some keywords in its schema.
For example Type. It’s not fully reserved word, in SQL’92 noted that
this word in list of candidates on inclusion.

What do we have besides “Type” that wants to be changed? At this point,
Big schema changes for 3.2 or 3.4 aren’t likely, but past that, I’d live
to get together a list of candidates for cleanup. I’ll also consider
imprecise or unclear naming inaddition to things that aren’t
ANSI-friendly.

Jesse
3

What do we have besides “Type” that wants to be changed? At this point,
Big schema changes for 3.2 or 3.4 aren’t likely, but past that, I’d live
to get together a list of candidates for cleanup. I’ll also consider
imprecise or unclear naming inaddition to things that aren’t
ANSI-friendly.

You could get a pretty good idea by looking for things that the psql
7.4 or later monitor displays with double quotes around it. That
tells you that psql is convinced that the word is somehow reserved.

A

Andrew Sullivan | ajs@crankycanuck.ca