pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedupdate syntax error?
3+ messages / 3 participants
[nested] [flat]
* update syntax error?
@ 2000-08-16 03:22 k.c. hemelstrand <kc@avsupport.com>
2000-08-20 19:27 ` Re: update syntax error? The Hermit Hacker <scrappy@hub.org>
2000-08-21 14:20 ` Re: update syntax error? mikeo <mikeo@spectrumtelecorp.com>
0 siblings, 2 replies; 3+ messages in thread
From: k.c. hemelstrand @ 2000-08-16 03:22 UTC (permalink / raw)
To: 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'
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: update syntax error?
2000-08-16 03:22 update syntax error? k.c. hemelstrand <kc@avsupport.com>
@ 2000-08-20 19:27 ` The Hermit Hacker <scrappy@hub.org>
1 sibling, 0 replies; 3+ messages in thread
From: The Hermit Hacker @ 2000-08-20 19:27 UTC (permalink / raw)
To: k.c. hemelstrand <kc@avsupport.com>; +Cc: 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@hub.org secondary: scrappy@{freebsd|postgresql}.org
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: update syntax error?
2000-08-16 03:22 update syntax error? k.c. hemelstrand <kc@avsupport.com>
@ 2000-08-21 14:20 ` mikeo <mikeo@spectrumtelecorp.com>
1 sibling, 0 replies; 3+ messages in thread
From: mikeo @ 2000-08-21 14:20 UTC (permalink / raw)
To: The Hermit Hacker <scrappy@hub.org>; k.c. hemelstrand <kc@avsupport.com>; +Cc: pgsql-sql
query should have a comma instead of the word and...
HTH
mikeo
At 04:27 PM 8/20/00 -0300, The Hermit Hacker wrote:
>
>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=# 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@hub.org secondary:
scrappy@{freebsd|postgresql}.org
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2000-08-21 14:20 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2000-08-16 03:22 update syntax error? k.c. hemelstrand <kc@avsupport.com>
2000-08-20 19:27 ` The Hermit Hacker <scrappy@hub.org>
2000-08-21 14:20 ` mikeo <mikeo@spectrumtelecorp.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox