[GENERAL] it works, but is it legal to separate schema/table/field references using spaces

2007-07-18 Thread Frank van Vugt
Hi, Just something I noticed to 'simply work': db=# select avg(pg_catalog. pg_stats . avg_width) from pg_stats; avg - 10.6654945054945055 (1 row) It seems that all whitespace between schema/table/field references is ignored? Not saying this is a bad

Re: [GENERAL] it works, but is it legal to separate schema/table/field references using spaces

2007-07-18 Thread Peter Eisentraut
Frank van Vugt wrote: db=# select avg(pg_catalog    .   pg_stats     . avg_width) from pg_stats; It seems that all whitespace between schema/table/field references is ignored? Sure, this is perfectly valid per SQL and what not. -- Peter Eisentraut http://developer.postgresql.org/~petere/