Oracle Select Syntax into Postgres

Question

I am converting Oracle Syntax into Postgres

SELECT MSN_INT_ID,
       MO_INT_ID,
       'Y'   "AIRMOVE"
  FROM MISSION_OBJECTIVE
 WHERE MO_MSN_CLASS_CD = 'AMV'
 GROUP BY MSN_INT_ID,
          MO_INT_ID

This part is confusing me:

SELECT MSN_INT_ID,
       MO_INT_ID,
       'Y'   "AIRMOVE"

What is the 'Y' "AIRMOVE" doing?

Vadim K. · Accepted Answer · 2010-01-18 22:19:34Z

1

The snippet 'Y' "AIRMOVE" introduces a computed column into the select-list named AIRMOVE whose value is always 'Y'.

answered Jan 18, 2010 at 22:19

Vadim K.

2,61122 silver badges30 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

OMG Ponies · Accepted Answer · 2010-01-18 22:18:24Z

1

It's a computed column, using a statically defined value.

answered Jan 18, 2010 at 22:18

OMG Ponies

334k85 gold badges536 silver badges508 bronze badges

Comments

Matthew Wood · Accepted Answer · 2010-01-19 17:25:56Z

1

Part of the confusion may be coming from PostgreSQL 8.3 or earlier, where the "AS" keyword is not optional.

Change:

'Y'   "AIRMOVE"

To:

'Y' AS "AIRMOVE"

And it should work fine. The keyword is optional starting in version 8.4, although I advocate always including it to avoid issues exactly like this one.

answered Jan 19, 2010 at 17:25

Matthew Wood

16.5k6 gold badges49 silver badges35 bronze badges

Collectives™ on Stack Overflow

Oracle Select Syntax into Postgres

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related