[SQL] Re: How NULL is interpreted in Pgsql

2001-05-15 Thread Per-Olof Pettersson
gresql but common to most(all) relational databases using SQL. To get the desired result you can add "OR id IS NULL". Result: select * from junk where id != 11 OR id IS NULL; Best regards Per-Olof Pettersson >>>>>>>>>>>>>>>>>> Orig

[SQL] Re: Select between two connections

2001-05-15 Thread Per-Olof Pettersson
Hi I think one way of accomplishing this is to use ODBC and thus an ODBC-client for the selects. There does not seem to be any support for it in Postgresql. (If not in later versions). Though I am not very experienced with it so someone more experienced should perhaps answer the question. Ho

[SQL] Re: how to remove ?

2001-05-15 Thread Per-Olof Pettersson
Hi Perhaps you have sent you commands in the subject-line. All commands should be sent by putting them in the body of the message. Best regards Per-Olof Pettersson >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<