Re: [SQL] Big query problem

2002-11-29 Thread Christoph Haller
> > DELETE FROM table WHERE col1='something' AND col2 IN > ('aasdoijhfoisdfsdoif','sdfsdfsdfsadfsdf', ... ); > > In the parantheses I have 6400 names, each about 20 characters. I'm > using libpq from C. This did not work very well, but the result was > very unexpected. > The conditional operator I

[SQL] Big query problem

2002-11-27 Thread Tomas Berndtsson
I'm using 7.2.1, trying to run a query like this: DELETE FROM table WHERE col1='something' AND col2 IN ('aasdoijhfoisdfsdoif','sdfsdfsdfsadfsdf', ... ); In the parantheses I have 6400 names, each about 20 characters. I'm using libpq from C. This did not work very well, but the result was very une