Re: Order by lower(column-alias) doesn't work...
От | Andreas Joseph Krogh |
---|---|
Тема | Re: Order by lower(column-alias) doesn't work... |
Дата | |
Msg-id | VisenaEmail.31.f9b7c96fd0fa46d2.1725b5848c8@tc7-visena обсуждение исходный текст |
Ответ на | Re: Order by lower(column-alias) doesn't work... (Geoff Winkless <pgsqladmin@geoff.dj>) |
Ответы |
Re: Order by lower(column-alias) doesn't work...
|
Список | pgsql-general |
På torsdag 28. mai 2020 kl. 14:50:54, skrev Geoff Winkless <pgsqladmin@geoff.dj>:
On Thu, 28 May 2020 at 13:14, Andreas Joseph Krogh <andreas@visena.com> wrote:
> This works:
> select p.firstname, p.lastname, p.firstname || p.lastname as fullname from onp_crm_person p order by fullname;
>
> But this doesn't:
> select p.firstname, p.lastname, p.firstname || p.lastname as fullname from onp_crm_person p order by lower(fullname);
> ERROR: column "fullname" does not exist
> LINE 1: ... as fullname from onp_crm_person p order by lower(fullname);
Wrap the original query in either a CTE or a temporary table.
eg
[..]
Yea, I was hoping to avoid that, as the query is generated and rewriting it is a pain...
Is there a way to define "sorting-rules" on custom-types so that I can have ORDER BY <my_array_of_custom_types_alias> and PG will pick my custom odering?
--
Andreas Joseph Krogh
Andreas Joseph Krogh
В списке pgsql-general по дате отправления: