From: | "k(dot)c(dot) hemelstrand" <kc(at)avsupport(dot)com> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | update syntax error? |
Date: | 2000-08-16 03:22:08 |
Message-ID: | 000601c00ac0$081275c0$122f7418@avsupport.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
Can anybody help with why I am receiving the error below?
Thanks
K.C.
parts=# \d av_parts
Table "av_parts"
Attribute | Type | Modifier
---------------------+-------------+-------------------------------------------------------
itemid | integer | not null default nextval('av_parts_itemid_seq'::text)
vendorid | integer |
partnumber | varchar(25) |
alternatepartnumber | varchar(25) |
nsn | varchar(15) |
description | varchar(50) |
condition | varchar(10) |
quantity | integer |
rawpartnumber | varchar(25) |
rawalternatenumber | varchar(25) |
rawnsnnumber | varchar(15) |
date | integer |
cagecode | varchar(10) |
Indices: av_parts_alternatepartnumber_in,
av_parts_itemid_key,
av_parts_nsn_index,
av_parts_partnumber_index,
av_parts_rawalternatenumber_ind,
av_parts_rawnsnnumber_index,
av_parts_rawpartnumber_index,
av_parts_vendorid_index
parts=# UPDATE av_parts
parts-# SET rawalternaternumber = 'NULL' AND alternatepartnumber = 'NULL'
parts-# WHERE rawalternatenumber = 'IVA81A';
ERROR: left-hand side of AND is type 'unknown', not 'bool'
From | Date | Subject | |
---|---|---|---|
Next Message | Webb Sprague | 2000-08-16 04:46:20 | Re: sql programming |
Previous Message | Michael Wagner | 2000-08-16 01:18:13 | sql programming |