Re: [Gnumed-devel] Demographics schema - urb postcode not null

[Karsten Hilbert]

On Fri, Oct 07, 2011 at 06:07:47PM -0700, Jim Busser wrote:

> ps if in psql you do
> 
>       select d_u.name, d_u.postcode, d_st.name from dem.urb d_u
>       inner join dem.state d_st
>       on d_u.id_state = d_st.id
>       where d_u.name = 'Leipzig' ;
> 
> yields
> 
>         name   | postcode |  name   
>       ---------+----------+---------
>        Leipzig | 04318    | Sachsen
>        Leipzig | 04317    | Sachsen
>       (2 rows)

What's the problem with that ?

Karsten
-- 
GPG key ID E4071346 @ gpg-keyserver.de
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346