Content-Type: multipart/alternative;
 boundary="------------DprjJpI9m01laX9ZzGa8g4R8"
Message-ID: <5fb866d1-8d2f-5118-18e2-9bbf227cbf1a@gmail.com>
Date: Mon, 31 Oct 2022 11:04:00 -0600
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.2.2
Content-Language: en-CA
To: pgsql-sql <pgsql-sql@lists.postgresql.org>
From: Rob Sargent <robjsargent@gmail.com>
Subject: access sub elements using any()
Archived-At: 
 <https://www.postgresql.org/message-id/5fb866d1-8d2f-5118-18e2-9bbf227cbf1a%40gmail.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------DprjJpI9m01laX9ZzGa8g4R8
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

Given an array of arrays ( e.g. v = {{1,'a'},{2,'b'},{3,'c'},{2,'d'}} ) 
is it possible, in plain sql, to access the first element of the listed 
arrays using the IN function?  Say I wanted just those with 2 as first 
element.  "where 2 = any(v[1])" does not work and not sure it's 
supported.   And I cannot craft a lhs to fussy-match each of the 
elements in v.  Can this be done?
--------------DprjJpI9m01laX9ZzGa8g4R8
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font face="Courier New, Courier, monospace">Given an array of
      arrays ( e.g. v = {{1,'a'},{2,'b'},{3,'c'},{2,'d'}} ) is it
      possible, in plain sql, to access the first element of the listed
      arrays using the IN function?  Say I wanted just those with 2 as
      first element.  "where 2 = any(v[1])" does not work and not sure
      it's supported.   And I cannot craft a lhs to fussy-match each of
      the elements in v.  Can this be done?<br>
    </font>
  </body>
</html>

--------------DprjJpI9m01laX9ZzGa8g4R8--