Re: Size of pg_rewrite

Matthias van de Meent <boekewurm+postgres(at)gmail(dot)com> writes:

> But, as text literal concatenations don't seem to get constant folded
> before storing them in the rules table, this rewrite of the views
> would result in long lines in the system_views.sql file, or we'd have
> to deal with the additional overhead of the append operator and cast
> nodes.

There is no need to use the concatenation operator to split array
constants across multiple lines. Newlines are fine either inside the
string (between array elements), or between two string string literals
(which become one string constant at parse time).

https://www.postgresql.org/docs/current/sql-syntax-lexical.html#SQL-SYNTAX-STRINGS

ilmari(at)[local]:5432 ~=# select
ilmari(at)[local]:5432 ~-# '{foo,
ilmari(at)[local]:5432 ~'# bar}'::text[],
ilmari(at)[local]:5432 ~-# '{bar,'
ilmari(at)[local]:5432 ~-# 'baz}'::text[];
┌───────────┬───────────┐
│ text │ text │
├───────────┼───────────┤
│ {foo,bar} │ {bar,baz} │
└───────────┴───────────┘
(1 row)

- ilmari