Thread: error...what to do?
<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>
Read the error text: > beckerbalab2=> SELECT ffix_ability.name, ffix_ability.cost ^^^^^ > beckerbalab2-> FROM ffix_can_learn NATURAL JOIN ffix_ability > beckerbalab2-> WHERE ffix_can_learn.character_name = 'Zidane' > beckerbalab2-> EXCEPT --this is the difference operator hope it works > beckerbalab2-> SELECT ffix_ability.name, ffix_ability.cost > beckerbalab2-> FROM ffix_can_learn NATURAL JOIN ffix_ability > beckerbalab2-> WHERE ffix_can_learn.character_name = 'Steiner'; > ERROR: No such attribute or function 'name' ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ Your ffix_ability table contains the columns "ability_name",'ability_description","type", and "cost". There's no column called "name". Try again with the line above as SELECT ffix_ability.ability_name.... ap ---------------------------------------------------------------------- Andrew J Perrin - http://www.unc.edu/~aperrin Assistant Professor of Sociology, U of North Carolina, Chapel Hill clists@perrin.socsci.unc.edu * andrew_perrin (at) unc.edu On Sat, 12 Oct 2002, George wrote: > The I am trying to do a set difference query. The query question is as > follows: 3.Find the names and costs of all abilities that Zidane can > learn, > > but that Steiner cannot. Can anyone help with this ..please. > > > > The tables to use are as follows: > > beckerbalab2=> select * from ffix_ability; > > ability_name | ability_description | > type | cost > > ----------------------+------------------------------------------------+ > ------------+------ > > Flee | Escape from battle with high probability. | > Active | 0 > > Cure | Restores HP of single/multiple. | > Active | 6 > > Power Break | Reduces the enemy's attack power. | > Active | 8 > > Thunder Slash | Causes Thunder damage to the enemy. | > Active | 24 > > Auto-Haste | Automatically casts Haste in battle. | > Passive | 9 > > Counter | Counterattacks when physically attacked. | > Passive | 8 > > MP+20% | Increases MP by 20% | > Passive | 8 > > Thievery | Deals physical damage to the target | > Active | 8 > > Fire | Causes Fire damage to single/multiple targets. | > Active | 6 > > Flare | Causes Non-Elemental damage. | > Active | 40 > > Leviathan | Causes water damage to all enemies. | > Active | 42 > > > > beckerbalab2=> select * from ffix_can_wear; > > character_name | equipment_name > > ----------------+---------------------- > > Dagger | Rod > > Dagger | Aquamarine > > Zidane | Aquamarine > > Vivi | Aquamarine > > Steiner | Diamond Sword > > Steiner | Ragnarok > > Dagger | Running Shoes > > Zidane | Running Shoes > > Vivi | Running Shoes > > Steiner | Running Shoes > > Dagger | Ritual Hat > > Zidane | Ritual Hat > > Vivi | Ritual Hat > > Dagger | Angel Earrings > > Zidane | Dagger > > Zidane | The Tower > > Dagger | Leather Hat > > Zidane | Leather Hat > > Vivi | Leather Hat > > Vivi | Black Robe > > Steiner | Aquamarine > > (21 rows) > > > > beckerbalab2=> SELECT ffix_ability.name, ffix_ability.cost > > beckerbalab2-> FROM ffix_can_learn NATURAL JOIN ffix_ability > > beckerbalab2-> WHERE ffix_can_learn.character_name = 'Zidane' > > beckerbalab2-> EXCEPT --this is the difference operator hope it works > > beckerbalab2-> SELECT ffix_ability.name, ffix_ability.cost > > beckerbalab2-> FROM ffix_can_learn NATURAL JOIN ffix_ability > > beckerbalab2-> WHERE ffix_can_learn.character_name = 'Steiner'; > > ERROR: No such attribute or function 'name' > > beckerbalab2=> > > > >
On Sat, 12 Oct 2002, George wrote: > beckerbalab2=> select * from ffix_ability; > > ability_name | ability_description | > type | cost > beckerbalab2=> SELECT ffix_ability.name, ffix_ability.cost ^^ ffix_ability.ability_name, right? Same below. > > beckerbalab2-> FROM ffix_can_learn NATURAL JOIN ffix_ability > > beckerbalab2-> WHERE ffix_can_learn.character_name = 'Zidane' > > beckerbalab2-> EXCEPT --this is the difference operator hope it works > > beckerbalab2-> SELECT ffix_ability.name, ffix_ability.cost > > beckerbalab2-> FROM ffix_can_learn NATURAL JOIN ffix_ability > > beckerbalab2-> WHERE ffix_can_learn.character_name = 'Steiner'; > > ERROR: No such attribute or function 'name' > > beckerbalab2=> > > > >