From: | George <beckergb(at)pacbell(dot)net> |
---|---|
To: | pgsql-sql(at)postgresql(dot)org |
Subject: | error...what to do? |
Date: | 2002-10-12 13:17:32 |
Message-ID: | 000501c271f1$b94f6380$f2f5e8d1@mirria |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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=>
From | Date | Subject | |
---|---|---|---|
Next Message | Stephan Szabo | 2002-10-12 14:57:39 | Re: DELETE command is getting blocked |
Previous Message | Bhuvan A | 2002-10-12 11:02:09 | DELETE command is getting blocked |