Revision 14141
Added by Aaron Marcuse-Kubitza over 10 years ago
trunk/schemas/util.sql | ||
---|---|---|
102 | 102 |
|
103 | 103 |
|
104 | 104 |
-- |
105 |
-- Name: derived_col_def; Type: TYPE; Schema: util; Owner: - |
|
106 |
-- |
|
107 |
|
|
108 |
CREATE TYPE derived_col_def AS ( |
|
109 |
col col, |
|
110 |
expr text |
|
111 |
); |
|
112 |
|
|
113 |
|
|
114 |
-- |
|
105 | 115 |
-- Name: geocoord; Type: TYPE; Schema: util; Owner: - |
106 | 116 |
-- |
107 | 117 |
|
... | ... | |
5251 | 5261 |
SET search_path = pg_catalog; |
5252 | 5262 |
|
5253 | 5263 |
-- |
5264 |
-- Name: CAST (util.check_constraint_def AS util.derived_col_def); Type: CAST; Schema: pg_catalog; Owner: - |
|
5265 |
-- |
|
5266 |
|
|
5267 |
CREATE CAST (util.check_constraint_def AS util.derived_col_def) WITH INOUT AS ASSIGNMENT; |
|
5268 |
|
|
5269 |
|
|
5270 |
-- |
|
5254 | 5271 |
-- Name: CAST (util.range AS numrange); Type: CAST; Schema: pg_catalog; Owner: - |
5255 | 5272 |
-- |
5256 | 5273 |
|
Also available in: Unified diff
schemas/util.sql: added derived_col_def type with cast from util.check_constraint_def