Postgres Pro
Downloads
Home   >   mailing lists

SQL syntax (column alias) - Mailing list pgsql-hackers

From snpe
Subject SQL syntax (column alias)
Date
Msg-id 200211101541.55030.snpe@snpe.co.yu
Whole thread Raw
In response to PostgreSQL JDBC and sub-select  (snpe <snpe@snpe.co.yu>)
Responses Re: SQL syntax (column alias)  (Rod Taylor <rbt@rbt.ca>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: "Iavor Raytchev"
Date:
Subject: Re: The database system is in recovery mode
Next
From: Tom Lane
Date:
Subject: Re: The database system is in recovery mode