From: | Ashesh Vashi <ashesh(dot)vashi(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers <pgadmin-hackers(at)postgresql(dot)org> |
Subject: | PATCH: Window Function support for PostgreSQL 8.4 |
Date: | 2009-01-12 08:56:08 |
Message-ID: | 496B05A8.9040702@enterprisedb.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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.
--
Regards,
Ashesh Vashi
EnterpriseDB INDIA: http://www.enterprisedb.com
Attachment | Content-Type | Size |
---|---|---|
WindowFunction_v1.patch | text/x-diff | 9.2 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Ashesh Vashi | 2009-01-12 08:58:09 | Re: Need suggestion for showing boolean parameters on Property Dialogs |
Previous Message | Hiroshi Saito | 2009-01-12 08:55:43 | Re: Position and size problem of SQL Dialog |