you try to do something like this select '00:01'::time + interval '10 minutes'
--- On Mon, 7/28/08, Rafael Domiciano <[EMAIL PROTECTED]> wrote: > From: Rafael Domiciano <[EMAIL PROTECTED]> > Subject: [ADMIN] Time Type > To: "pgsql-admin@postgresql.org" <pgsql-admin@postgresql.org> > Date: Monday, July 28, 2008, 6:16 PM > Hi there, > > I'm trying to do some as following and I couldn't: > select '00:01:00'::time + '00:10:00'::time > ERROR: operator is not unique: time without time zone + > time without time > zone at character 127 > HINT: Could not choose a best candidate operator. You > might need to add > explicit type casts. > > Postgres version: 8.3.3 > > Anyone knows anything? > > Regards, > > Rafael Domiciano -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin