Re: Is there a better way to do this?

From: Michael Glaesemann <grzm(at)seespotcode(dot)net>
To: "D(dot) Dante Lorenso" <dante(at)lorenso(dot)com>
Cc: Wei Weng <wweng(at)kencast(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Is there a better way to do this?
Date: 2007-08-28 22:04:17
Message-ID: FD35B58D-1259-4BBC-907F-5CD0D859F4C6@seespotcode.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Aug 28, 2007, at 16:55 , D. Dante Lorenso wrote:

> RETURN time + (days || ' days')::INTERVAL;

It's bad practice to concatenate like this. Use time + days *
interval '1 day' and be done with it.

Michael Glaesemann
grzm seespotcode net

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ben 2007-08-28 22:10:34 Re: autovacuum not running
Previous Message Osvaldo Rosario Kussama 2007-08-28 21:59:26 Re: Is there a better way to do this?