Postgres Pro
Downloads
Home   >   mailing lists

it works, but is it legal to separate schema/table/field references using spaces - Mailing list pgsql-general

From Frank van Vugt
Subject it works, but is it legal to separate schema/table/field references using spaces
Date
Msg-id 200707181348.53687.ftm.van.vugt@foxi.nl
Whole thread Raw
Responses Re: it works, but is it legal to separate schema/table/field references using spaces  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-general
Tree view 
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.

pgsql-general by date:

Previous
From: "Jayakumar_Mukundaraju"
Date:
Subject: Re: redirecting output of pg_dump
Next
From: Nico Sabbi
Date:
Subject: REQUEST: option to auto-generate new sequences with CREATE TABLE (LIKE)