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

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=>
> 
>  
> 
>