Received: from localhost (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 85935476BBD
	for <pgsql-sql@postgresql.org>; Fri, 18 Oct 2002 13:59:21 -0400 (EDT)
Received: from megazone.bigpanda.com (megazone.bigpanda.com [63.150.15.178])
	by postgresql.org (Postfix) with ESMTP id B88FC476B83
	for <pgsql-sql@postgresql.org>; Fri, 18 Oct 2002 13:59:17 -0400 (EDT)
Received: by megazone.bigpanda.com (Postfix, from userid 1001)
	id 792F4D609; Fri, 18 Oct 2002 10:59:17 -0700 (PDT)
Received: from localhost (localhost [127.0.0.1])
	by megazone.bigpanda.com (Postfix) with ESMTP
	id 6EE8D5C02; Fri, 18 Oct 2002 10:59:17 -0700 (PDT)
Date: Fri, 18 Oct 2002 10:59:17 -0700 (PDT)
From: Stephan Szabo <sszabo@megazone23.bigpanda.com>
To: George <beckergb@pacbell.net>
Cc: <pgsql-sql@postgresql.org>
Subject: Re: error...what to do?
In-Reply-To: <000501c271f1$b94f6380$f2f5e8d1@mirria>
Message-ID: <20021018105831.Q26104-100000@megazone23.bigpanda.com>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
X-Virus-Scanned: by AMaViS new-20020517
X-Archive-Number: 200210/236
X-Sequence-Number: 9953

On Sat, 12 Oct 2002, George wrote:

> beckerbalab2=> select * from ffix_ability;
>
> ability_name     |              ability_description               |
> type    | cost

> beckerbalab2=> SELECT ffix_ability.name, ffix_ability.cost
^^ ffix_ability.ability_name, right?  Same below.
>
> 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=>
>
>
>
>