| From: | mikeo <mikeo(at)spectrumtelecorp(dot)com> |
|---|---|
| To: | The Hermit Hacker <scrappy(at)hub(dot)org>, "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-21 14:20:24 |
| Message-ID: | 3.0.1.32.20000821102024.009316e0@pop.spectrumtelecorp.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)hub(dot)org secondary:
scrappy(at){freebsd|postgresql}.org
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig L. Ching | 2000-08-21 14:23:46 | RE: Re: [SQL] database design and diagraming book recom mendations.. |
| Previous Message | The Hermit Hacker | 2000-08-20 22:49:51 | RE: Speed or configuration |