Re: select - Mailing list pgsql-novice

From Tom Lane
Subject Re: select
Date
Msg-id 17213.1047308115@sss.pgh.pa.us
Whole thread Raw
In response to select  ("cristi" <cristi@dmhi.ct.ro>)
List pgsql-novice
"cristi" <cristi@dmhi.ct.ro> writes:
> I have an integer vector: 101,105,120... and a table with an integer field
> named "cod" .
> I want to select the records who contains in field named "cod" one of the
> vector values.

SELECT * FROM table_name WHERE cod IN (101,105,120...);

            regards, tom lane

pgsql-novice by date:

Previous
From: bryan@flyingiranch.com
Date:
Subject: Value of sequence last inserted
Next
From: "Delao, Darryl W"
Date:
Subject: General Performance questions