From: | The Hermit Hacker <scrappy(at)hub(dot)org> |
---|---|
To: | "k(dot)c(dot) hemelstrand" <kc(at)avsupport(dot)com> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: update syntax error? |
Date: | 2000-08-20 19:27:17 |
Message-ID: | Pine.BSF.4.21.0008201626550.801-100000@thelab.hub.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
UPDATE <table> SET field1=<value>,field2=<value>
On Tue, 15 Aug 2000, k.c. hemelstrand wrote:
> 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'
>
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
From | Date | Subject | |
---|---|---|---|
Next Message | Franz J Fortuny | 2000-08-20 21:50:04 | RE: Speed or configuration |
Previous Message | Stephan Szabo | 2000-08-20 18:11:58 | Re: Speed or configuration |