obtaining ARRAY position for a given match

From: Pedro Doria Meunier <pdoria(at)netmadeira(dot)com>
To: Postgresql Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: obtaining ARRAY position for a given match
Date: 2009-11-19 12:53:00
Message-ID: 4B053FAC.5010408@netmadeira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Hi,

I'm trying to get the array position for a given match as thus:

This gets me the record for a given match:
SELECT * FROM garmin_units WHERE 'L' = ANY (protocol_tag);

Ok. so far so good...
But what about getting the array position at which 'L' is stored?

Searching the Postgresql docs gives me no answer... :(
Am I on a wild goose chase?

Any insight highly appreciated ;)

BR,
Pedro Doria Meunier.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.9 (GNU/Linux)
Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/

iEYEARECAAYFAksFP6IACgkQ2FH5GXCfxAuasgCgu/d68fkg16r1OF/2QSLnmwhW
gjYAniyQ1Mn/72323NSznxgakF4dn98k
=tWbI
-----END PGP SIGNATURE-----

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Eisentraut 2009-11-19 12:58:34 Re: Enum on-disk format
Previous Message Henk van Lingen 2009-11-19 11:04:47 text search query planning