3674954 - Syntax error in PostgreSQL index expression due to incorrect placement of ASC or DESC - SAP PD

• In a PostgreSQL Physical Data Model (PDM), an index expression is customized with options such as NULLS FIRST or NULLS LAST.
• PD appends the sorting order option (ASC or DESC) at the end of the index expression.
• Executing the generated SQL results in a syntax error:
     SQL Error [42601]: ERROR: syntax error at or near 'ASC'.

• SAP PowerDesigner (PD) 16.7
• PostgreSQL

postgresql, psql, index, expression, indexexpression, NULLS FIRST, NULLS LAST, ASC, DESC, syntax, error, 42601, CR831379, CR#831379, 831379 , KBA , BC-SYB-PD , PowerDesigner , Known Error