Re: Newbie table definition question

* Steven Klassen <sklassen(at)commandprompt(dot)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