get the array value?

From: "Charles(dot)Hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: get the array value?
Date: 2008-12-25 06:15:34
Message-ID: dcad04c8-3b42-45d1-9b55-3f78977894e2@d42g2000prb.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

name[] = { JOHN , ALEX , TEST ,""}

SQL : select name from table1 where 'TEST' = any (name)

return: { JOHN , ALEX , TEST }

in this sql command, how can i get the index of 'TEST' is 3 ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Gerhard Wiesinger 2008-12-25 09:58:46 Information about Pages, row versions of tables, indices
Previous Message Andrej Podzimek 2008-12-25 05:51:54 Automatic CRL reload