Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group