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: Pine.LNX.3.96.981126233348.2855A-100000@tte.tamu.edu (view raw or flat)
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


pgsql-interfaces by date

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

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