Re: questions

I've sent this onto the mailng lists...


On Mon, 11 Jan 1999, Jixue Jerry Liu wrote:

> Dear Marc,
>
> My name is Jixue Liu, a PhD student in the School of Computer Science,
> University of South Australia. I am studying view maintenance in OR
> Systems. The model I study most and the system I use is Postgres. I
> appreciate the contribution of Postgres group to the field. Now I have
> some questions about the usage of the system.
>
> 1. How to define a relation with an attribute which takes set values?
> 2. How to populate instances to a table referring another table? An
> example:
>    Create table cities (name text, population float);
>    Insert into cities values ('Adelaide',100.0);
>    Create table people(name text, live_in cities);
>    How to insert a tuple into people saying that 'Jerry' lives in
> Adelaide?
>
>
> I am looking forward to hearing from you.
>
> Jixue Liu
>
>
>
>

Marc G. Fournier
Systems Administrator @ hub.org
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org