Thread: BUG #13494: Postgresql database displays first column data on merging of two columns in the Select statement

The following bug has been logged on the website:

Bug reference:      13494
Logged by:          Atul Srivastava
Email address:      atulcs178@gmail.com
PostgreSQL version: 9.1.9
Operating system:   Windows 7
Description:

PostgreSQL database displays data of the first column,under second column
name, When we merge two columns in the Select statement. However it should
throw error if we don't put any comma (,) in between both columns.

Note : We are getting error message like ("syntax error"). if we are trying
to merge three columns. However it is not throwing any error if we merged
two columns (it's just showing data of the first column,under second column
name)

On 2015-07-08 11:29:55 +0000, atulcs178@gmail.com wrote:
> PostgreSQL database displays data of the first column,under second column
> name, When we merge two columns in the Select statement. However it should
> throw error if we don't put any comma (,) in between both columns.

You mean like "SELECT column_a column_b", right? In that case column_b
is the alias for column_a. The SQL standard has made the AS for column
aliases optional.

Regards,

Andres