Postgres Pro
Downloads
Home   >   mailing lists

Finding a value in an array field - Mailing list pgsql-general

From Roberto (SmartBit)
Subject Finding a value in an array field
Date
Msg-id 001e01c2763f$b6efc7e0$1501a8c0@NoteBook
Whole thread Raw
Responses Re: Finding a value in an array field
List pgsql-general
Tree view 
How can I know if a value is into an array field?

something like:

  SELECT field1, field2 FROM myTableName
  WHERE 10 in myArrayField

PS: I do NOT know then number of array elements!

tia

Roberto de Amorim - +55 48 346-2243
Software engineer at SmartBit Software
Delphi and Interbase consultant

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: PostgreSQL query failed: COPY state must be terminated first
Next
From: Stephan Szabo
Date:
Subject: Re: imploding/using arrays for IN (...)