From: George <beckergb@pacbell.net>
To: pgsql-sql@postgresql.org
Subject: error...what to do?
Date: Sat, 12 Oct 2002 06:17:32 -0700
Message-ID: <000501c271f1$b94f6380$f2f5e8d1@mirria> (raw)
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=>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: beckergb@pacbell.net
Subject: Re: error...what to do?
In-Reply-To: <000501c271f1$b94f6380$f2f5e8d1@mirria>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox