Re: [GENERAL] String Comparison and NULL

2008-04-30 Thread seijin
On Apr 29, 7:36 am, [EMAIL PROTECTED] (Tom Lane) wrote: > Andreas Kretschmer <[EMAIL PROTECTED]> writes: > >>> ... and I do something like "select id where animal <> 'Cat';" then > >>> shouldn't 1, 3, 4 and 5 be picked? As it is I only get 1, 4 and 5. > >>> NULL is not 'Cat'. I realize that if I

[GENERAL] String Comparison and NULL

2008-04-29 Thread seijin
Hi, I'm fairly new to PG and databases in general so this may very well be a problem in my thought process. If I have a simple table with an ID (integer) and Animal (text) like this... 1 Dog 2 Cat 3 NULL 4 Horse 5 Pig 6 Cat 7 Cat ... and I do something like "select id where animal <> 'Cat';" t

[GENERAL] libeay32.dll and libpq.dll

2007-11-30 Thread seijin
I'm working on a Windows application that will connect to a Postgresql database without having through ODBC. I'm using libpq and testing with a simple PQconnectdb/PQfinish call but the application fails as soon as PQconnectdb is called. The error I get says that libeay32.dll is missing. I have n