From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
---|---|
To: | George <beckergb(at)pacbell(dot)net> |
Cc: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: error...what to do? |
Date: | 2002-10-18 17:59:17 |
Message-ID: | 20021018105831.Q26104-100000@megazone23.bigpanda.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
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=>
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2002-10-18 18:01:18 | Re: functions that return a dataset or set of rows |
Previous Message | Andrew Perrin | 2002-10-18 17:53:19 | Re: error...what to do? |