A couple of TODO notes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: pgsql-hackers(at)postgreSQL(dot)org
Subject: A couple of TODO notes
Date: 2003-10-20 01:12:47
Message-ID: 5453.1066612367@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Some comments on random TODO entries:

* Allow INET subnet tests using non-constants

This should say "Allow ... to be indexed" as it's otherwise a nonissue.

* ARRAYS
o -Allow arrays to be ORDER'ed

Although Joe implemented ordering operators, he didn't get around to
adding MIN()/MAX() support for arrays. Seems like if you can do '<'
then you should be able to do MIN().

* Allow CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops)
fails index can't store constant parameters

This is done as of 7.4.

* Improve handling of index scans for NULL

I think this should read "Allow use of indexes to search for NULLs".
ISTM "improve" implies that there's something there to improve...

* CURSOR
o Allow BINARY option to SELECT, just like DECLARE

This is either done or rendered irrelevant, depending on your point of
view, by the V3 protocol.

o Add SET SCHEMA

What is this supposed to do (and how's it different from SET SEARCH_PATH)?

* -Support statement-level triggers (Neil)

If we're going to remove this as done, we ought to put in a separate
TODO item to allow such triggers to get at the sets of modified rows.
People seem to think that that's a standard part of the capability.

* Wire Protocol Changes
o Add optional textual message to NOTIFY
o Allow fastpast to pass values in portable format

Those are both done as far as the protocol is concerned, and therefore
should be moved to some other category. The fastpath issue probably
should be under libpq, since it's only a matter of redesigning the API
that libpq exposes for this feature.

o Special passing of binary values in platform-neutral format (bytea?)

That's done, period.

regards, tom lane

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Christopher Kings-Lynne 2003-10-20 01:55:54 Re: A couple of TODO notes
Previous Message Tom Lane 2003-10-20 00:35:50 Re: Unicode upper() bug still present