[GENERAL] Re: Create an empty record

2001-05-19 Thread Per-Olof Pettersson
Oh I forgot Naturally it works with setting eg procuct in this case to null but it does not seem very clean. INSERT INTO product(product) VALUES(null); Does anybody have a clean way to do this? Best regards Per-Olof Pettersson >>>>>>>>>>>>>>>>

[GENERAL] Re: Not a PG question: SCSI question

2001-05-15 Thread Per-Olof Pettersson
recommend PHP 4.0.5. It is, among other things, a matter of issuing a rollback at the end of the request on each page. Best regards Per-Olof Pettersson >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<&

[GENERAL] Re: What's the best front end/client under MS Windows?

2001-05-15 Thread Per-Olof Pettersson
Hi I like WinSQL LITE. There you get all messages. You can get it from: http://www.indus-soft.com/ It uses ODBC to connect. Best regards Per-Olof Pettersson >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<&

[GENERAL] Re: Which Front End for Postgresql

2001-05-15 Thread Per-Olof Pettersson
riting-routines ;-) Best of luck Per-Olof Pettersson >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2001-05-16, 04:08:06, [EMAIL PROTECTED] (Al Frick) wrote regarding Which Front End

[GENERAL] Re: index doesn't work for null?

2001-05-15 Thread Per-Olof Pettersson
Hi Alex I have no idea if it is a known issue. Though "field=null" is not allowed in standard SQL. The correct statement should be "select from xx where field IS NULL;". Perhaps it will be handled better (or not). Best regards Per-Olof Pettersson >>>>