Re: [GENERAL] Select from Java Strings

4/07/2011 1:45 AM, David Johnston wrote: On Jul 3, 2011, at 11:13, Daron Ryan daron.r...@gmail.com wrote: I have strings from java and need to check which ones are not present in the db. Can I use

[GENERAL] Select from Java Strings

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?

[GENERAL] Search for lists

Hello, I need to search a table to find sets of rows that have a column matching itself for the whole set and another column matching row for row with a list I am going to supply. The result I should receive should be value of the column that matches itself. For example given the following

Re: [GENERAL] Search for lists

Thanks. On 19/06/2011 8:09 AM, David Johnston wrote: An alternative approach would be to select using a IN condition on the where clause and group by column 1 and column 2. Then, using this as a sub-select group by the resultant column 1 and a count on column two. The matching identifiers

[GENERAL] Duplicated Fields

I am designing a database that will include at lot of duplicated data. Does Postgres perform many optimisations to eliminate duplications of fields or should I create additional tables to reference myself? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

[GENERAL] Cannot start Postgres : invalid data in PID file

Problem: Cannot start Postgres Platform: Postgres 8.3, Windows Vista Home Error Message: pg_ctl: invalid data in PID file C:/Program Files/PostgreSQL/8.3/data/postmaster.pid I run postgres on Windows Vista Home Edition. It normally runs as a service but is not starting. I created a command