Erol KAHRAMAN wrote:
hi guys,
i am newbie in postgresql. I need some help; i am trying to write like
this:
select * from TABLE where IN ('value1','valeue2',....)
You'll need to provide a column-name:
... WHERE mycolumn IN (...)
but is it possible to give values from file.
select * from TABLE where IN file
Not directly. You'd normally handle this in whatever language you are
using to query the database.
If you have a lot of values, you might find it useful to read them into
a temporary table.
CREATE TEMP TABLE my_values (...);
COPY my_values ... FROM <filename>;
ANALYSE my_values;
SELECT * FROM main_table JOIN my_values ON main_table_column =
my_values_column
Of course, that assumes you have your values one per line - see the
manuals for details of what COPY can handle.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
