* Steven Klassen <[EMAIL PROTECTED]> [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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to