Revision 2838
Added by Aaron Marcuse-Kubitza over 12 years ago
| schemas/functions.sql | ||
|---|---|---|
| 237 | 237 |
-- Name: _alt_0; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 238 | 238 |
-- |
| 239 | 239 |
|
| 240 |
CREATE INDEX _alt_0 ON _alt USING btree ("0");
|
|
| 240 |
CREATE INDEX _alt_0 ON _alt USING btree ((COALESCE("0", '\\N'::text)));
|
|
| 241 | 241 |
|
| 242 | 242 |
|
| 243 | 243 |
-- |
| 244 | 244 |
-- Name: _alt_1; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 245 | 245 |
-- |
| 246 | 246 |
|
| 247 |
CREATE INDEX _alt_1 ON _alt USING btree ("1");
|
|
| 247 |
CREATE INDEX _alt_1 ON _alt USING btree ((COALESCE("1", '\\N'::text)));
|
|
| 248 | 248 |
|
| 249 | 249 |
|
| 250 | 250 |
-- |
| 251 | 251 |
-- Name: _alt_2; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 252 | 252 |
-- |
| 253 | 253 |
|
| 254 |
CREATE INDEX _alt_2 ON _alt USING btree ("2");
|
|
| 254 |
CREATE INDEX _alt_2 ON _alt USING btree ((COALESCE("2", '\\N'::text)));
|
|
| 255 | 255 |
|
| 256 | 256 |
|
| 257 | 257 |
-- |
| 258 | 258 |
-- Name: _alt_3; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 259 | 259 |
-- |
| 260 | 260 |
|
| 261 |
CREATE INDEX _alt_3 ON _alt USING btree ("3");
|
|
| 261 |
CREATE INDEX _alt_3 ON _alt USING btree ((COALESCE("3", '\\N'::text)));
|
|
| 262 | 262 |
|
| 263 | 263 |
|
| 264 | 264 |
-- |
| 265 | 265 |
-- Name: _alt_4; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 266 | 266 |
-- |
| 267 | 267 |
|
| 268 |
CREATE INDEX _alt_4 ON _alt USING btree ("4");
|
|
| 268 |
CREATE INDEX _alt_4 ON _alt USING btree ((COALESCE("4", '\\N'::text)));
|
|
| 269 | 269 |
|
| 270 | 270 |
|
| 271 | 271 |
-- |
| 272 | 272 |
-- Name: _alt_5; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 273 | 273 |
-- |
| 274 | 274 |
|
| 275 |
CREATE INDEX _alt_5 ON _alt USING btree ("5");
|
|
| 275 |
CREATE INDEX _alt_5 ON _alt USING btree ((COALESCE("5", '\\N'::text)));
|
|
| 276 | 276 |
|
| 277 | 277 |
|
| 278 | 278 |
-- |
| 279 | 279 |
-- Name: _alt_6; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 280 | 280 |
-- |
| 281 | 281 |
|
| 282 |
CREATE INDEX _alt_6 ON _alt USING btree ("6");
|
|
| 282 |
CREATE INDEX _alt_6 ON _alt USING btree ((COALESCE("6", '\\N'::text)));
|
|
| 283 | 283 |
|
| 284 | 284 |
|
| 285 | 285 |
-- |
| 286 | 286 |
-- Name: _alt_7; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 287 | 287 |
-- |
| 288 | 288 |
|
| 289 |
CREATE INDEX _alt_7 ON _alt USING btree ("7");
|
|
| 289 |
CREATE INDEX _alt_7 ON _alt USING btree ((COALESCE("7", '\\N'::text)));
|
|
| 290 | 290 |
|
| 291 | 291 |
|
| 292 | 292 |
-- |
| 293 | 293 |
-- Name: _alt_8; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 294 | 294 |
-- |
| 295 | 295 |
|
| 296 |
CREATE INDEX _alt_8 ON _alt USING btree ("8");
|
|
| 296 |
CREATE INDEX _alt_8 ON _alt USING btree ((COALESCE("8", '\\N'::text)));
|
|
| 297 | 297 |
|
| 298 | 298 |
|
| 299 | 299 |
-- |
| 300 | 300 |
-- Name: _alt_9; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 301 | 301 |
-- |
| 302 | 302 |
|
| 303 |
CREATE INDEX _alt_9 ON _alt USING btree ("9");
|
|
| 303 |
CREATE INDEX _alt_9 ON _alt USING btree ((COALESCE("9", '\\N'::text)));
|
|
| 304 | 304 |
|
| 305 | 305 |
|
| 306 | 306 |
-- |
| 307 | 307 |
-- Name: _alt_unique; Type: INDEX; Schema: functions; Owner: -; Tablespace: |
| 308 | 308 |
-- |
| 309 | 309 |
|
| 310 |
CREATE UNIQUE INDEX _alt_unique ON _alt USING btree (ensure_not_null("0"), ensure_not_null("1"), ensure_not_null("2"), ensure_not_null("3"), ensure_not_null("4"), ensure_not_null("5"), ensure_not_null("6"), ensure_not_null("7"), ensure_not_null("8"), ensure_not_null("9"));
|
|
| 310 |
CREATE UNIQUE INDEX _alt_unique ON _alt USING btree ((COALESCE("0", '\\N'::text)), (COALESCE("1", '\\N'::text)), (COALESCE("2", '\\N'::text)), (COALESCE("3", '\\N'::text)), (COALESCE("4", '\\N'::text)), (COALESCE("5", '\\N'::text)), (COALESCE("6", '\\N'::text)), (COALESCE("7", '\\N'::text)), (COALESCE("8", '\\N'::text)), (COALESCE("9", '\\N'::text)));
|
|
| 311 | 311 |
|
| 312 | 312 |
|
| 313 | 313 |
-- |
Also available in: Unified diff
schemas/functions.sql: _alt: Changed indexes to use `COALESCE` to match what sql_gen now does