PATCH: Window Function support for PostgreSQL 8.4
| От | Ashesh Vashi |
|---|---|
| Тема | PATCH: Window Function support for PostgreSQL 8.4 |
| Дата | |
| Msg-id | 496B05A8.9040702@enterprisedb.com обсуждение исходный текст |
| Ответы |
Re: PATCH: Window Function support for PostgreSQL 8.4
|
| Список | pgadmin-hackers |
Hi All,
I have been working on support for WINDOW function in PostgreSQL 8.4.
Please find the patch for it.
Problem definition:
- Add an entry to the property list to indicate whether or not a
function is a window function.
- Modify the reverse engineered SQL to include the WINDOW keyword
where appropriate.
- Modify the function dialogue to allow the user to create window
functions (adding a checkbox seems the sensible way, which becomes
read-only in edit mode).
- For window functions, supported language will be 'c' only.
New function syntax can be found at:
http://developer.postgresql.org/pgdocs/postgres/sql-createfunction.html
As I asked a suggestion on utilizing the space while using boolean
parameters, Dave Page has suggested to use wxCheckListBox, but it has
limitation of "Not able to disable particular checkbox in that list."
I come up with a simple solution:
Put all the boolean parameters together and instead of putting them in
each row, kept them in 2x2 table. It does not look that so decent. :(
But, we can use this approach, until we come up with any good solution
for that.
I have been working on support for WINDOW function in PostgreSQL 8.4.
Please find the patch for it.
Problem definition:
- Add an entry to the property list to indicate whether or not a
function is a window function.
- Modify the reverse engineered SQL to include the WINDOW keyword
where appropriate.
- Modify the function dialogue to allow the user to create window
functions (adding a checkbox seems the sensible way, which becomes
read-only in edit mode).
- For window functions, supported language will be 'c' only.
New function syntax can be found at:
http://developer.postgresql.org/pgdocs/postgres/sql-createfunction.html
As I asked a suggestion on utilizing the space while using boolean
parameters, Dave Page has suggested to use wxCheckListBox, but it has
limitation of "Not able to disable particular checkbox in that list."
I come up with a simple solution:
Put all the boolean parameters together and instead of putting them in
each row, kept them in 2x2 table. It does not look that so decent. :(
But, we can use this approach, until we come up with any good solution
for that.
--
В списке pgadmin-hackers по дате отправления: