Re: Newbie table definition question - Mailing list pgsql-general

From Steven Klassen
Subject Re: Newbie table definition question
Date
Msg-id 20041017090816.GA1604@commandprompt.com
Whole thread Raw
In response to Re: Newbie table definition question  (Steven Klassen <sklassen@commandprompt.com>)
List pgsql-general
* 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

pgsql-general by date:

Previous
From: Steven Klassen
Date:
Subject: Re: Newbie table definition question
Next
From: David Garamond
Date:
Subject: timezone abbreviation in timestamp string input