Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 32763475EBB for ; Sat, 12 Oct 2002 09:17:27 -0400 (EDT) Received: from mta7.pltn13.pbi.net (mta7.pltn13.pbi.net [64.164.98.8]) by postgresql.org (Postfix) with ESMTP id 835D5475EA4 for ; Sat, 12 Oct 2002 09:17:26 -0400 (EDT) Received: from mirria ([209.232.245.242]) by mta7.pltn13.pbi.net (iPlanet Messaging Server 5.1 (built May 7 2001)) with ESMTP id <0H3V00KF8E956L@mta7.pltn13.pbi.net> for pgsql-sql@postgresql.org; Sat, 12 Oct 2002 06:17:30 -0700 (PDT) Date: Sat, 12 Oct 2002 06:17:32 -0700 From: George Subject: error...what to do? To: pgsql-sql@postgresql.org Message-id: <000501c271f1$b94f6380$f2f5e8d1@mirria> MIME-version: 1.0 X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Mailer: Microsoft Outlook, Build 10.0.3416 Content-type: multipart/alternative; boundary="Boundary_(ID_i5C0k0+2DxXmrtOacHaLLg)" Importance: Normal X-Priority: 3 (Normal) X-MSMail-priority: Normal X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200210/218 X-Sequence-Number: 9935 This is a multi-part message in MIME format. --Boundary_(ID_i5C0k0+2DxXmrtOacHaLLg) Content-type: text/plain; charset=us-ascii Content-transfer-encoding: 7BIT 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=> --Boundary_(ID_i5C0k0+2DxXmrtOacHaLLg) Content-type: text/html; charset=us-ascii Content-transfer-encoding: 7BIT

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

 

--Boundary_(ID_i5C0k0+2DxXmrtOacHaLLg)--