error...what to do? - Mailing list pgsql-sql

<div class="Section1"><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">The I am trying to do a set difference query. The query question is as follows: 3.Find the names and
costsof all abilities that Zidane can learn,</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial">     but that Steiner cannot. Can anyone help with this ….please.</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">The tables to use are as follows: </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">beckerbalab2=> select * from ffix_ability;</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">ability_name     |              ability_description               |    type    |
cost</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 

font-family:Arial">----------------------+------------------------------------------------+------------+------</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Flee                 | Escape from battle with high probability.      | Active     |   
0</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Cure                 | Restores HP of single/multiple.                | Active     |   
6</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Power Break          | Reduces the enemy's attack power.              | Active     |   
8</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Thunder Slash        | Causes Thunder damage to the enemy.            | Active     |  
24</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Auto-Haste           | Automatically casts Haste in battle.           | Passive    |   
9</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Counter              | Counterattacks when physically attacked.       | Passive    |   
8</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">MP+20%               | Increases MP by 20%                            | Passive    |   
8</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Thievery             | Deals physical damage to the target            | Active     |   
8</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Fire                 | Causes Fire damage to single/multiple targets. | Active     |   
6</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Flare                | Causes Non-Elemental damage.                   | Active     |  
40</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">Leviathan            | Causes water damage to all enemies.            | Active     |  
42</span></font><pclass="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">beckerbalab2=> select * from ffix_can_wear;</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> character_name |    equipment_name    </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">----------------+----------------------</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Dagger         | Rod                 </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Dagger         | Aquamarine          </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Zidane         | Aquamarine          </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Vivi           | Aquamarine          </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Steiner        | Diamond Sword       </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Steiner        | Ragnarok            </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Dagger         | Running Shoes       </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Zidane         | Running Shoes       </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Vivi           | Running Shoes       </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Steiner        | Running Shoes       </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Dagger         | Ritual Hat          </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Zidane         | Ritual Hat          </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Vivi           | Ritual Hat          </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Dagger         | Angel Earrings      </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Zidane         | Dagger              </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Zidane         | The Tower           </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Dagger         | Leather Hat         </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Zidane         | Leather Hat         </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Vivi           | Leather Hat         </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Vivi           | Black Robe          </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial"> Steiner        | Aquamarine          </span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">(21 rows)</span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font><p class="MsoNormal"><font face="Arial" size="2"><span style="font-size:10.0pt;
font-family:Arial">beckerbalab2=> SELECT ffix_ability.name, ffix_ability.cost</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">beckerbalab2-> FROM ffix_can_learn NATURAL JOIN  ffix_ability  </span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">beckerbalab2->  WHERE ffix_can_learn.character_name = 'Zidane'</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">beckerbalab2-> EXCEPT --this is the difference operator hope it works </span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">beckerbalab2-> SELECT ffix_ability.name, ffix_ability.cost</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">beckerbalab2-> FROM ffix_can_learn NATURAL JOIN  ffix_ability  </span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">beckerbalab2-> WHERE ffix_can_learn.character_name = 'Steiner';</span></font><p
class="MsoNormal"><fontface="Arial" size="2"><span style="font-size:10.0pt;
 
font-family:Arial">ERROR:  No such attribute or function 'name'</span></font><p class="MsoNormal"><font face="Arial"
size="2"><spanstyle="font-size:10.0pt;
 
font-family:Arial">beckerbalab2=></span></font><p class="MsoNormal"><font face="Arial" size="2"><span
style="font-size:10.0pt;
font-family:Arial"> </span></font></div>