Hello David,
This is a simplified version of my own attempt:
SELECT *
FROM ("oxford", "webster")
WHERE NOT ( columnName = ANY (SELECT name FROM dictionaries))
The idea is that "oxford" and "webster" come from the Java program
end up in the column called columnName.
I think your answer is quite sufficient though and that it I should
use option 1 since there don't seem to be any other options which
are any better.
Thanks,
Daron.
On 4/07/2011 1:45 AM, David Johnston wrote:
<blockquote
cite="mid:C6F72661-0FFC-4C25-876B-DEDB9408A016@yahoo.com"
type="cite">
On Jul 3, 2011, at 11:13, Daron Ryan <<a
moz-do-not-send="true" href="mailto:daron.ryan@gmail.com">daron.ryan@gmail.com>
wrote:
<span class="Apple-style-span" style="border-collapse:
separate; color: rgb(0, 0, 0); font-family: 'Times New
Roman'; font-style: normal; font-variant: normal;
font-weight: normal; letter-spacing: normal; line-height:
normal; orphans: 2; text-indent: 0px; text-transform: none;
white-space: normal; widows: 2; word-spacing: 0px;
font-size: medium;"><span class="Apple-style-span"
style="border-collapse: collapse; font-family:
Tahoma,Arial,Helvetica,sans-serif; font-size: 13px;
line-height: 17px; white-space: pre-wrap;">I have strings
from
java and need to check which ones are not present in the
db. Can
I use a select statement to do this by making it search my
strings as though they are a table?
There are multiple ways to accomplish your goal, which each
have merits and issues. Â
1. Java for loop and look for each string one at a time
2. Convert your strings into a Postgres array and query all
of them at once
3. Insert your strings into a table and execute a query to
check them all at once
If you want more help than this you should provide more
specific details about your situation. Â Your question seems odd
at first reading, especially the part where you want to find out
which strings are NOT present.
David J