get the array value? - Mailing list pgsql-general

From Charles.Hou
Subject get the array value?
Date
Msg-id dcad04c8-3b42-45d1-9b55-3f78977894e2@d42g2000prb.googlegroups.com
Whole thread Raw
List 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 ?



pgsql-general by date:

Previous
From: Andrej Podzimek
Date:
Subject: Automatic CRL reload
Next
From: Gerhard Wiesinger
Date:
Subject: Information about Pages, row versions of tables, indices