Re: [SQL] Query information needed

2005-10-19 Thread Oliver Elphick
On Thu, 2005-10-13 at 05:50 -0700, [EMAIL PROTECTED] wrote: > Dear all, > > I have a table created with this specifications: > > CREATE TABLE cdr ( > calldate timestamp with time zone NOT NULL default now(), > clid varchar(80) NOT NULL default '', > src varchar(80) NOT NULL default '', >

Re: [SQL] Query information needed

2005-10-18 Thread Michael Glaesemann
On Oct 13, 2005, at 21:50 , [EMAIL PROTECTED] wrote: Dear all, I have a table created with this specifications: CREATE TABLE cdr ( calldate timestamp with time zone NOT NULL default now(), clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT N

[SQL] Query information needed

2005-10-18 Thread djzanky
Dear all, I have a table created with this specifications: CREATE TABLE cdr ( calldate timestamp with time zone NOT NULL default now(), clid varchar(80) NOT NULL default '', src varchar(80) NOT NULL default '', dst varchar(80) NOT NULL default '', dcontext varchar(80) NOT NULL default '