Re: Newbie table definition question

* Steven Klassen <sklassen@commandprompt.com> [2004-10-17 01:52:47 -0700]:

> xinu=> select * from items_types_view;
>  id | item_name | type_name
> ----+-----------+-----------
>   1 | Apple     | fruit
>   2 | Orange    | fruit
>   3 | Brocolli  | fruit
>   4 | Lettuce   | fruit
> (4 rows)

And after I fixed the types for the latter items:

xinu=> select * from items_types_view;
 id | item_name | type_name
----+-----------+-----------
  1 | Apple     | fruit
  2 | Orange    | fruit
  3 | Brocolli  | vegatable
  4 | Lettuce   | vegatable
(4 rows)

--
Steven Klassen - Lead Programmer
Command Prompt, Inc. - http://www.commandprompt.com/
PostgreSQL Replication & Support Services, (503) 667-4564