IS OF

From: Joe Conway <mail(at)joeconway(dot)com>
To: "Hackers (PostgreSQL)" <pgsql-hackers(at)postgresql(dot)org>
Subject: IS OF
Date: 2003-03-22 23:56:13
Message-ID: 3E7CF81D.1000203@joeconway.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2003-03-23 00:24:56 Re: IS OF
Previous Message Joe Conway 2003-03-22 23:48:12 Re: Fwd: [GENERAL] statement id

Browse pgsql-patches by date

  From Date Subject
Next Message Tom Lane 2003-03-23 00:24:56 Re: IS OF
Previous Message Bruce Momjian 2003-03-22 03:46:34 Re: Add CLUSTER ON to pg_dumps