pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Erik Wasser <erik.wasser@iquer.net>
To: pgsql-sql@postgresql.org
Subject: Re: Howto turn an integer into an interval?
Date: Wed, 6 Oct 2004 10:13:27 +0200
Message-ID: <200410061013.28369.erik.wasser@iquer.net> (raw)
In-Reply-To: <Pine.LNX.4.44.0410051443550.13144-100000@matrix.gatewaynet.com>
References: <Pine.LNX.4.44.0410051443550.13144-100000@matrix.gatewaynet.com>

On Tuesday 05 October 2004 13:44, you wrote:

> If you know for sure that you are keeping resend_interval in seconds,
> then try as follows:
>
> foodb=# SELECT (59::text||' secs')::interval;
>  interval
> ----------
>  00:00:59
> (1 row)


Thanks for this solution and the others. It's now working very fine. B-)

-- 
So long... Fuzz



view thread (5+ messages)

Message-ID: <200410061013.28369.erik.wasser@iquer.net>
Permalink:  ../200410061013.28369.erik.wasser@iquer.net/
Also on:    postgresql.org/message-id/200410061013.28369.erik.wasser@iquer.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: erik.wasser@iquer.net
  Subject: Re: Howto turn an integer into an interval?
  In-Reply-To: <200410061013.28369.erik.wasser@iquer.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox