PATCH: Window Function support for PostgreSQL 8.4 - Mailing list pgadmin-hackers

From Ashesh Vashi
Subject PATCH: Window Function support for PostgreSQL 8.4
Date
Msg-id 496B05A8.9040702@enterprisedb.com
Whole thread Raw
Responses Re: PATCH: Window Function support for PostgreSQL 8.4  ("Dave Page" <dpage@pgadmin.org>)
List 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

pgadmin-hackers by date:

Previous
From: "Hiroshi Saito"
Date:
Subject: Re: Position and size problem of SQL Dialog
Next
From: Ashesh Vashi
Date:
Subject: Re: Need suggestion for showing boolean parameters on Property Dialogs