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

From: Frank van Vugt <ftm(dot)van(dot)vugt(at)foxi(dot)nl>
To: pgsql-general(at)postgresql(dot)org
Subject: it works, but is it legal to separate schema/table/field references using spaces
Date: 2007-07-18 11:48:52
Message-ID: 200707181348.53687.ftm.van.vugt@foxi.nl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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 thing per se, it just surprised me and made me wonder
if this intended to work like this and/or legal per sql-specs ;)

db=# select version();
version
------------------------------------------------------------------------
PostgreSQL 8.2.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.4.3
(1 row)

--
Best,

Frank.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dimitri Fontaine 2007-07-18 12:34:52 Re: multirow insert
Previous Message A. Kretschmer 2007-07-18 10:32:04 Re: redirecting output of pg_dump