Indexing an Array field element

From: David Sweeney <david(at)tte(dot)tamu(dot)edu>
To: PostgreSQL Interfaces Mailing List <pgsql-interfaces(at)postgresql(dot)org>
Subject: Indexing an Array field element
Date: 1998-11-27 05:37:20
Message-ID: Pine.LNX.3.96.981126233348.2855A-100000@tte.tamu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Is there a way to create an index on an array field element. For example:

@fieldwholename = {"Mr.","David","Sean","Sweeney","Ph.D."}

can I create an index on the lastname (that is, element 3)?

David Sweeney
Texas A&M University

Browse pgsql-interfaces by date

  From Date Subject
Next Message Radu COLCERIU 1998-11-27 06:53:59
Previous Message The Hermit Hacker 1998-11-26 19:14:22 libpq++ for Windows...