Revision 12571
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 2080 | 2080 |
WHERE (col).type != ANY('{bigint}'::regtype[]) -- not a count col
|
| 2081 | 2081 |
)); |
| 2082 | 2082 |
|
| 2083 |
-- values() |
|
| 2083 |
-- values_()
|
|
| 2084 | 2084 |
SELECT util.mk_keys_func($1, COALESCE( |
| 2085 | 2085 |
NULLIF(ARRAY( |
| 2086 | 2086 |
SELECT col FROM util.typed_cols($1) col |
| 2087 | 2087 |
WHERE (col).type = ANY('{bigint}'::regtype[]) -- is a count col
|
| 2088 | 2088 |
), ARRAY[]::util.col_cast[]) |
| 2089 | 2089 |
, ARRAY(SELECT util.typed_cols($1))) -- no count cols, so use all cols |
| 2090 |
, 'values'); |
|
| 2090 |
, 'values_');
|
|
| 2091 | 2091 |
$_$; |
| 2092 | 2092 |
|
| 2093 | 2093 |
|
Also available in: Unified diff
bugfix: schemas/util.sql: mk_keys_func(regtype): values() function: must be called values_() instead because `values` is a keyword