Hi,
    Some databases (like Teradata) support the following syntax:

    select col1, col2*20 as col2_1, col2_1*200 as col3_1 from your_table;

    The last element in the target list can refer the second one using its 
alias.

    This feature is similar to some programming languages (like Lisp)'s let*​.

    For Postgres, it seems the only way is to write a subquery and then a new 
target list.

    Will Postgres plan to support this feature?

    Thanks a lot!

Reply via email to