Re: [SQL] Time difference without intervals

2002-11-09 Thread Bruno Wolff III
On Fri, Nov 08, 2002 at 16:11:05 -0500, Tom Lane <[EMAIL PROTECTED]> wrote: > Roberto Mello <[EMAIL PROTECTED]> writes: > > Is there any way to make a timestamp difference operation not return an > > interval? I'd like to get hours, minutes and seconds only, not the "1 day" > > or whatnot. > > I

[SQL] table protein does not have an attribute oid? why?

2002-11-09 Thread Zhidian Du
Dear All: I want to create a delete cascade in children tables. The primary key of parent table is oid. CREATE TABLE Link ( Protein_ID oid, Link varchar(128) CONSTRAINT one REFERENCES Protein (oid) ON DELETE CASCADE ); Create child table is ok. When I insert a record in

[SQL] Parent table has not oid?

2002-11-09 Thread Zhidian Du
Dear All: Please disregerd my last email. I want to create a delete cascade in children tables. The primary key of parent table is oid. CREATE TABLE Link ( Protein_ID oid CONSTRAINT one REFERENCES Protein (oid) ON DELETE CASCADE, Link varchar(128) ); Create child table is ok.