Re: [HACKERS] IS OF

2003-03-22 Thread Joe Conway
Gavin Sherry wrote: 8.14 to be exact. 8.18 in SQL200x. I don't think the current implementation quite meets the spec however: regression=# select f2 is null, f2 is of(int) from bar; ?column? | ?column? --+-- f| t t| t (2 rows) If I read the spec correctly, the

Re: [HACKERS] IS OF

2003-03-22 Thread Gavin Sherry
On Sat, 22 Mar 2003, Tom Lane wrote: > Joe Conway <[EMAIL PROTECTED]> writes: > > Pretty handy! But I couldn't find it documented anywhere -- is it? > > I think Thomas did that in one of his last batches of changes, and then > disappeared without adding the documentation. Feel free to contribute

Re: [HACKERS] IS OF

2003-03-22 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > Pretty handy! But I couldn't find it documented anywhere -- is it? I think Thomas did that in one of his last batches of changes, and then disappeared without adding the documentation. Feel free to contribute some. I believe it is supposed to be a SQL99 f