[SQL] Noob question about types and lists

2005-10-06 Thread xchris
Hi, i'm really new to postgres and have some doubts. Hope somebody could explain. Let say i have a table of "clients" and every client has a small number of addresses. (let say 3) My approch is to create a type "address" like this (simplified) CREATE TYPE address AS ( street VARC

Re: [SQL] Noob question about types and lists

2005-10-06 Thread xchris
On gio, 2005-10-06 at 12:20 +0100, Richard Huxton wrote: > From the manuals... > I didn't search very well.Sorry! > > However - I don't think you want to anyway. If you're going to use a > relational database, try a relational approach! Typically, you would do > something like [cut] I want