IS OF - Mailing list pgsql-hackers

From Joe Conway
Subject IS OF
Date
Msg-id 3E7CF81D.1000203@joeconway.com
Whole thread Raw
Responses Re: IS OF  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
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);
}

Works like so:

regression=# select array[1,1.2] is of (numeric[]); ?column?
---------- t
(1 row)

Pretty handy! But I couldn't find it documented anywhere -- is it?

Thanks,

Joe



pgsql-hackers by date:

Previous
From: Joe Conway
Date:
Subject: Re: Fwd: [GENERAL] statement id
Next
From: Tom Lane
Date:
Subject: Re: IS OF