Search Postgresql Archives

Re: Select from Java Strings

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Jul 3, 2011, at 11:13, Daron Ryan <daron.ryan@xxxxxxxxx> 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 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux