Ingres Community Forums - View Single Post

kschendel · 2009-01-10

Ingres is technically compliant to the "Entry Level" SQL-92 spec only. I don't have the SQL-92 spec in front of me (thank goodness!!!), but I doubt that domains are Entry Level.

I don't mean to blow you off, but domains as they exist in SQL (as far as I know) are a quite limited construct. They are equivalent to a globally defined CHECK constraint, and add little or no value to most business logic constraints. I suppose it would be nice if Ingres supported domains, but it has to be not real high up on the list of things to do to Ingres.

2009-01-10	#9 (permalink)
kschendel Ingres Community Join Date: Mar 2007 Location: Pittsburgh, PA Posts: 1,095	Ingres is technically compliant to the "Entry Level" SQL-92 spec only. I don't have the SQL-92 spec in front of me (thank goodness!!!), but I doubt that domains are Entry Level. I don't mean to blow you off, but domains as they exist in SQL (as far as I know) are a quite limited construct. They are equivalent to a globally defined CHECK constraint, and add little or no value to most business logic constraints. I suppose it would be nice if Ingres supported domains, but it has to be not real high up on the list of things to do to Ingres.