Re: HISTORY updated, 7.3 branded - Mailing list pgsql-hackers
From | Bruce Momjian |
---|---|
Subject | Re: HISTORY updated, 7.3 branded |
Date | |
Msg-id | 200209041845.g84Ij2F25669@candle.pha.pa.us Whole thread Raw |
In response to | Re: HISTORY updated, 7.3 branded (Tom Lane <tgl@sss.pgh.pa.us>) |
Responses |
Re: HISTORY updated, 7.3 branded
|
List | pgsql-hackers |
Tom Lane wrote: > Bruce Momjian <pgman@candle.pha.pa.us> writes: > > Please review the HISTORY file. > > PostgreSQL now support ALTER TABLE ... DROP COLUMN functionality. > > s/support/supports/ > > Functions can now return sets, with multiple rows > and multiple columns. You specify these functions in > the SELECT FROM clause, similar to a table or view. > > I don't like this description: it's always been possible for functions > to return sets, it was just hard to use the feature. Try to explain > what we really added. Maybe: > > Functions returning sets (multiple rows) and/or tuples (multiple > columns) are now much easier to use than before. You can call > such a function in the SELECT FROM clause, treating its output > like a table. Such a function can be declared to return RECORD, > with the actual output column set varying from one query to the > next. Also, plpgsql functions can now return sets. Well, this is a summary section. That seems like too much detail. I don't remember every seeing a function returning sets before. Can you give an example? I can add the word "'easily' return sets" but I don't think it is that easy. > Both multibyte and locale are now enabled by default. > > s/enabled by default/always enabled/ --- AFAIK it is impossible to > disable them, so "by default" is pretty misleading. Done. > > By default, functions can now take up to 32 parameters, and > identifiers can be up to 64 bytes long. > > s/64/63/ Oops, got it. > Add pg_locks table to show locks (Neil) > > s/table/view/ Yep. > > EXPLAIN now outputs as a query (Tom) > > This doesn't seem to belong under the Performance heading. I had it there because EXPLAIN is a performance tool, though I wondered about that logic too. Move to utilities. > > Display sort keys in EXPLAIN (Tom) > > Likewise. Moved. > > Restrict comments to the current database > > Should probably say "comments on databases". Changed to: Restrict comment to the current database > > Increase maximum number of function parameters to 32 (Bruce) momjian > > This line seems to need editing? Fixed. > > Modify a few error messages for consistency (Bruce) momjian > > This too. Fixed. > > Cleanups in array internal handling (Tom) > > Joe should get credit on that one. Done. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania19073
pgsql-hackers by date: