Re: [GENERAL] Select from Java Strings

2011-07-04 Thread Harald Fuchs
In article <4e116e11.1030...@gmail.com>, Daron Ryan writes: > 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 progr

Re: [GENERAL] Select from Java Strings

2011-07-04 Thread Daron Ryan
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 c

Re: [GENERAL] Select from Java Strings

2011-07-03 Thread David Johnston
On Jul 3, 2011, at 11:13, Daron Ryan wrote: > 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

[GENERAL] Select from Java Strings

2011-07-03 Thread Daron Ryan
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?