Re: error...what to do?

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(at)perrin(dot)socsci(dot)unc(dot)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=>
>
>
>
>