If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > PostgreSQL > Logical operators

Reply
 
LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 05-21-04, 14:00
nstamato nstamato is offline
Registered User
 
Join Date: May 2004
Posts: 3
Logical operators

Hey,

Can someone tell me if PostgreSQL supports the logical operator XOR?

Thanx

Nikitas Stamatopoulos
Reply With Quote
  #2 (permalink)  
Old 05-21-04, 15:26
le mogwai le mogwai is offline
Registered User
 
Join Date: Apr 2003
Posts: 23
Reply With Quote
  #3 (permalink)  
Old 05-27-04, 18:45
nstamato nstamato is offline
Registered User
 
Join Date: May 2004
Posts: 3
The tutorial you gave me a link to just mentions that there is support for the bitwise XOR operator not the logical XOR operator. They are different things. Anyway, as it turns out, PostgreSQL DOES NOT support the XOR logical operator.

cheers,

Nikitas Stamatopoulos
Reply With Quote
  #4 (permalink)  
Old 06-10-04, 12:36
karim2k karim2k is offline
Registered User
 
Join Date: Apr 2003
Location: Tunisia
Posts: 192
It did

Quote:
Originally Posted by nstamato
The tutorial you gave me a link to just mentions that there is support for the bitwise XOR operator not the logical XOR operator. They are different things. Anyway, as it turns out, PostgreSQL DOES NOT support the XOR logical operator.

cheers,

Nikitas Stamatopoulos
# bitwise XOR 17 # 5
__________________
Open up
Take a look to my Blog http://www****ndom.com/karim2k
Reply With Quote
  #5 (permalink)  
Old 06-18-04, 21:04
nstamato nstamato is offline
Registered User
 
Join Date: May 2004
Posts: 3
It didn't

Ok, logic operators are either value operations or bitwise operations. Bitwise operations consider the individual bits separately unlike the value operations that treat the while value as an entity. And when you don't specify bitwise operator, you assume it's the value operation. So, PostgreSQL DOES NOT SUPPORT the XOR value operator. Check this manual and tell me if you think differently:

manual
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On