Re: [SQL] Time difference without intervals

2002-11-10 Thread Tom Lane
Roberto Mello <[EMAIL PROTECTED]> writes: > On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane wrote: >> I think your complaint is not that you get an interval, but that you >> want it displayed differently. See to_char() ... > It was not a complaint in any way. I apologize if I came across like

Re: [SQL] Time difference without intervals

2002-11-10 Thread Roberto Mello
On Fri, Nov 08, 2002 at 04:11:05PM -0500, Tom Lane 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 think your complain

Re: [SQL] Parent table has not oid?

2002-11-10 Thread Tom Lane
"Zhidian Du" <[EMAIL PROTECTED]> writes: > CREATE TABLE Link ( >Protein_ID oid >CONSTRAINT one >REFERENCES Protein (oid) >ON DELETE CASCADE, >Link varchar(128) > ); > When I insert a record into this child table, it says > "ERROR: constraint one: table protein does not have an a