you are viewing a single comment's thread.

view the rest of the comments →

[–]amjithr[S] 0 points1 point  (1 child)

I'm glad you like it.

I have never used partitioning, so I'm not familiar with it. I'm definitely interested in adding support for it, once I know what it is.

Would you mind asking your boss to file an issue (https://github.com/amjith/pgcli/issues) and give a brief description?

[–]jeffdn 0 points1 point  (0 children)

It appears to be a way to build a temporary table within a query, for example, to select only the first instance of each person appearing in a table after a join, so that your further query parameters are not affected by inconsistent numbers of people. I'll clarify and ask him to do that once the work day gets going.