[KDb] [Bug 387798] Referencing column aliases in SELECT and WHERE does not work in PostgreSQL

[Jarosław Staniek]

https://bugs.kde.org/show_bug.cgi?id=387798

--- Comment #1 from Jarosław Staniek <stan...@kde.org> ---
Extended scope to the SELECT section. Neither this work in PostgreSQL:

SELECT city as c, c || '!' FROM customers;

We have the same soultions as for WHERE:

1. SELECT c, c || '!' FROM (SELECT *, city AS c FROM customers) AS city_alias

or 2. SELECT customers.city as c, customers.city || '!' FROM customers

-- 
You are receiving this mail because:
You are watching all bug changes.