Re: Adding Indexes on Expressions

Hi Anil,

This looks good to me.

On Fri, Jun 30, 2023 at 3:00 PM Anil Sahoo <anil(dot)sahoo(at)enterprisedb(dot)com>
wrote:

> Hi Hackers,
>
> I am currently working on the feature *#2595*.
>
> Earlier using pgAdmin 4, we are able to create indexes by mentioning
> columns only, but Indexes on Expressions is about creating expressions of
> the single columns or multiple columns. This will help to retrieve data in
> a faster way when we use WHERE or ORDER BY clause.
>
> I have made a dummy UI for that and divided the Definition tab to 2 tabs
> such as *Definition* and *Columns*. The Columns tab will have the
> *Columns/Expressions* control and *Include Columns* control and all other
> controls that are earlier present in the Definition tab except Columns
> control and Include Columns control are kept as it is.
>
> Attached the new design, please review it.
>
> Thanks
> Anil Sahoo
>
>
> --
>
> <http://www.enterprisedb.com>
>
> *Anil Sahoo*
>
> Software Engineer
>
> www.enterprisedb.com
>
> Power to Postgres
>
> <https://www.linkedin.com/company/edbpostgres>
> <https://twitter.com/edbpostgres?lang=en>
> <https://www.facebook.com/EDBpostgres>
> <https://www.instagram.com/EDBpostgres/>
>

--
Thanks,
Aditya Toshniwal
pgAdmin Hacker | Sr. Software Architect | *enterprisedb.com*
<https://www.enterprisedb.com/>
"Don't Complain about Heat, Plant a TREE"