* 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