column labels now with obligatory 'as'

From: Zeugswetter Andreas DBT <Andreas(dot)Zeugswetter(at)telecom(dot)at>
To: "'pgsql-hackers(at)hub(dot)org'" <pgsql-hackers(at)hub(dot)org>
Subject: column labels now with obligatory 'as'
Date: 1998-01-09 15:17:13
Message-ID: 219F68D65015D011A8E000006F8590C60F2523@sdexcsrv1.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,

Have just tried 9. Jan snapshot on AIX 4.1.5,
compiles with gcc not with cc (fails in heaptuple.c), aix won't get
defined though, did a -Daix

The as keyword is now obligatory as in:

regression=> select name a, age b from emp;
ERROR: parser: parse error at or near "a"

strange results as in (should be syntax error):
regression=> select name 'a' from emp;
?column?
--------
a
(1 row)

Since the other(DBMS)s don't insist on the as I would suggest not to be
stricter than the others even if it needs a lot of brainwork. (Tom ?)

Might try something like:
if not registered right unary operator then label (probably no
good)
or
force non alpha 1. char for unary operators (i think this is
best)
or even
disallow creation of right and left unary operators alltogether
(can always use function instead)

hm... really not easy...
Comments ?

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter T Mount 1998-01-09 15:32:22 Re: [HACKERS] grant broken
Previous Message Vadim B. Mikheev 1998-01-09 15:10:06 Re: subselects