Quick Links

SQL syntax (column alias)

From:	snpe <snpe(at)snpe(dot)co(dot)yu>
To:	<pgsql-hackers(at)postgresql(dot)org>
Subject:	SQL syntax (column alias)
Date:	2002-11-10 15:41:54
Message-ID:	200211101541.55030.snpe@snpe.co.yu
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-hackers pgsql-jdbc

Hello,
Query :

select id i
from tab

don't work in PostgreSQL

I know that

select id as i
from tab

work, but I think that AS in 'as cluse' is optional

Please comment.

regards
Haris Peco

In response to

PostgreSQL JDBC and sub-select at 2002-11-09 17:51:41 from snpe

Responses

Re: SQL syntax (column alias) at 2002-11-10 16:15:59 from Rod Taylor
Re: SQL syntax (column alias) at 2002-11-10 16:38:37 from Joe Conway

Browse pgsql-general by date

	From	Date	Subject
Next Message	Rod Taylor	2002-11-10 16:15:59	Re: SQL syntax (column alias)
Previous Message	snpe	2002-11-10 14:52:58	Re: [HACKERS] PostgreSQL JDBC and sub-select

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Rod Taylor	2002-11-10 16:15:59	Re: SQL syntax (column alias)
Previous Message	snpe	2002-11-10 14:52:58	Re: [HACKERS] PostgreSQL JDBC and sub-select

Browse pgsql-jdbc by date

	From	Date	Subject
Next Message	Rod Taylor	2002-11-10 16:15:59	Re: SQL syntax (column alias)
Previous Message	snpe	2002-11-10 14:52:58	Re: [HACKERS] PostgreSQL JDBC and sub-select