error...what to do?

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

Responses

Browse pgsql-sql by date

  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