Revision 2338
Added by Aaron Marcuse-Kubitza over 12 years ago
| functions.sql | ||
|---|---|---|
| 70 | 70 |
|
| 71 | 71 |
CREATE TABLE "_toBool" ( |
| 72 | 72 |
result boolean, |
| 73 |
not_null boolean DEFAULT true NOT NULL, |
|
| 73 | 74 |
value text |
| 74 | 75 |
); |
| 75 | 76 |
|
| ... | ... | |
| 80 | 81 |
|
| 81 | 82 |
CREATE TABLE "_toDouble" ( |
| 82 | 83 |
result double precision, |
| 84 |
not_null boolean DEFAULT true NOT NULL, |
|
| 83 | 85 |
value text |
| 84 | 86 |
); |
| 85 | 87 |
|
| ... | ... | |
| 90 | 92 |
|
| 91 | 93 |
CREATE TABLE "_toTimestamp" ( |
| 92 | 94 |
result timestamp with time zone, |
| 95 |
not_null boolean DEFAULT true NOT NULL, |
|
| 93 | 96 |
value text |
| 94 | 97 |
); |
| 95 | 98 |
|
Also available in: Unified diff
schemas/vegbien.sql, schemas/functions.sql: Relational functions: Added dummy not_null column to provide a column to use in LEFT JOIN filter-out filters