On 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 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?
are those with a count equal to the number of entries in the
original IN condition.
Basically count how many of values each distinct key in column 1 matches and
keep those keys where the count and the number of values match.
David J.
On Jun 18, 2011, at 17:51, Daron Ryan wrote:
Hello,
I
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
I have a table with just 2 columns, 1 for a character array and one an
integer index. I need to process a string such as to find out the index
for it in the table if it is already there or insert it and then find
out it's index which is auto generated otherwise. Is there a way to do
this in a
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 to
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
