Re: [HACKERS] IS OF

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

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

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

[HACKERS] IS OF

While messing around in gram.y I came across a production like this: | a_expr IS OF '(' type_list ')' %prec IS { $$ = (Node *) makeSimpleA_Expr(AEXPR_OF, "=", $1, (Node *) $5); } | a_expr IS NOT OF '(' type_list ')' %prec IS { $$ = (Node *) makeSimpleA_Expr(AEXPR_OF, "!=", $1, (Node *) $6); }