On 20 Mar 2001 at 23:07 (-0000), Peter Morgan wrote:
| Here's the SP that toggles a Bit datatype. How would I make it comething
| like
| ???
| update pcpmanufacturers set def = not (def) where ManufID = @ManufID
update pcpmanufacturers set def=(1-def) where ManufID=@ManufID;
hth.
brent
--
- - - - - - - -=( d a m o n b r e n t v e r n e r )=- - - - - - - - -
c e r t i f i e d n o s o u r c o p h o b i c
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://www.postgresql.org/search.mpl
