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: dcad04c8-3b42-45d1-9b55-3f78977894e2@d42g2000prb.googlegroups.com (view raw or flat)
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

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-2014 The PostgreSQL Global Development Group