Received: from ns3.khmere.com (209-249-64-251.snj0.flashcom.net [209.249.64.251]) by hub.org (8.9.3/8.9.3) with ESMTP id QAA71882 for ; Fri, 17 Sep 1999 16:07:11 -0400 (EDT) (envelope-from nathan@penguincomputing.com) Received: from penguincomputing.com (adsl-216-100-224-114.dsl.snfc21.pacbell.net [216.100.224.114]) by ns3.khmere.com (8.9.2/8.8.7) with ESMTP id MAA48537 for ; Sat, 18 Sep 1999 12:59:27 GMT Sender: nathan@ns3.khmere.com Message-ID: <37E29F8F.4162E6EF@penguincomputing.com> Date: Fri, 17 Sep 1999 13:07:43 -0700 From: nathan X-Mailer: Mozilla 4.61 [en] (X11; I; Linux 2.2.5-15 i586) X-Accept-Language: en, ja MIME-Version: 1.0 To: "pgsql-sql@postgreSQL.org" Subject: Select statements on a table that has null fields Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Question : Postgres 6.5.1 Linux Redhat 6.0 I have a table that has 6 columns, 3 of the columns have data in every field but the last 3 columns have some data and some null fields. When I do a select statement and query on the columns that have a null field I crash the connection. Is this normal or is this a bug or am I doing something wrong ? Example: create table sales_info ( product_id int8 product_desc char(20), in_stock int8, //some fields will be null on_shelf int8, //some fields will be null total_sold int8 item_cost float8 ) select * from sales_info where in_stock > 3; This will crash if the in_stock column has some rows with null values. Nathan