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

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


pgsql-general by date

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

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