PATCH: Window Function support for PostgreSQL 8.4

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

Responses

Browse pgadmin-hackers by date

  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