Revision 13643
Added by Aaron Marcuse-Kubitza over 10 years ago
| trunk/schemas/util.sql | ||
|---|---|---|
| 4452 | 4452 |
/* unexpand expanded * expressions. any list of 5+ cols from the same table is |
| 4453 | 4453 |
treated as a * expression. */ |
| 4454 | 4454 |
SELECT regexp_replace($1, |
| 4455 |
'\y((?:"[^"\s]+"|\w+)\.)(?:"[^"\s]+"|\w+)'|| --1st col, which lacks separator before |
|
| 4455 |
'((?:"[^"\s]+"|\w+)\.)(?:"[^"\s]+"|\w+)'|| |
|
| 4456 |
/* 1st col, which lacks separator before. |
|
| 4457 |
*note*: can't prepend \y because it considers only \w chars, not " */ |
|
| 4456 | 4458 |
'(,[[:blank:]]* |
| 4457 | 4459 |
[[:blank:]]*)\1(?:"[^"\s]+"|\w+)'|| -- 2nd col, which has separator before |
| 4458 | 4460 |
'(?:\2\1(?:"[^"\s]+"|\w+)){4,}', -- later cols, w/ same table name and separator
|
Also available in: Unified diff
bugfix: schemas/util.sql: view_def_to_orig(): 1st col: can't prepend \y because it considers only \w chars, not "