[SQL] Error 42704

2012-10-08 Thread Kim Bisgaard
Hi, I am trying to model a macro system where I have simple things, and more complex thing consisting of simple things. To do that I have "invented" this table definition: CREATE TABLE params ( param_id serial NOT NULL, name text NOT NULL, unit text, real_param_id integer[], CONSTRA

Re: [SQL] checking the gaps in intervals

2012-10-08 Thread Gavin Flower
On 06/10/12 11:42, Anton Gavazuk wrote: Hi dear community, Have probably quite simple task but cannot find the solution, Imagine the table A with 2 columns start and end, data type is date start end 01 dec. 10 dec 11 dec. 13 dec 17 dec. 19 dec . If I have interval, fo

Re: [SQL] checking the gaps in intervals

2012-10-08 Thread Gavin Flower
On 06/10/12 11:42, Anton Gavazuk wrote: Hi dear community, Have probably quite simple task but cannot find the solution, Imagine the table A with 2 columns start and end, data type is date start end 01 dec. 10 dec 11 dec. 13 dec 17 dec. 19 dec . If I have interval, fo