From bee217924d51af8cf0411167bfc8a7eb55122577 Mon Sep 17 00:00:00 2001
From: Tom Lane
Date: Sun, 29 Jun 2003 00:33:44 +0000
Subject: Support expressions of the form 'scalar op ANY (array)' and 'scalar
 op ALL (array)', where the operator is applied between the lefthand scalar
 and each element of the array.  The operator must yield boolean; the result
 of the construct is the OR or AND of the per-element results, respectively.

Original coding by Joe Conway, after an idea of Peter's.  Rewritten
by Tom to keep the implementation strictly separate from subqueries.
---
 src/pl/plpgsql/src/pl_exec.c | 12 +++++++++++-
 1 file changed, 11 insertions(+), 1 deletion(-)

(limited to 'src/pl')

diff --git a/src/pl/plpgsql/src/pl_exec.c b/src/pl/plpgsql/src/pl_exec.c
index efb423541a9..54f2b3a8803 100644
--- a/src/pl/plpgsql/src/pl_exec.c
+++ b/src/pl/plpgsql/src/pl_exec.c
@@ -3,7 +3,7 @@
  *			  procedural language
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/pl/plpgsql/src/pl_exec.c,v 1.86 2003/04/24 21:16:44 tgl Exp $
+ *	  $Header: /cvsroot/pgsql/src/pl/plpgsql/src/pl_exec.c,v 1.87 2003/06/29 00:33:44 tgl Exp $
  *
  *	  This software is copyrighted by Jan Wieck - Hamburg.
  *
@@ -3520,6 +3520,16 @@ exec_simple_check_node(Node *node)
 				return TRUE;
 			}
 
+		case T_ScalarArrayOpExpr:
+			{
+				ScalarArrayOpExpr *expr = (ScalarArrayOpExpr *) node;
+
+				if (!exec_simple_check_node((Node *) expr->args))
+					return FALSE;
+
+				return TRUE;
+			}
+
 		case T_BoolExpr:
 			{
 				BoolExpr   *expr = (BoolExpr *) node;
-- 
cgit v1.2.3