Postgres Pro
Downloads
Home   >   mailing lists

Re: Is there a better way to do this? - Mailing list pgsql-general

From Michael Glaesemann
Subject Re: Is there a better way to do this?
Date
Msg-id FD35B58D-1259-4BBC-907F-5CD0D859F4C6@seespotcode.net
Whole thread Raw
In response to Re: Is there a better way to do this?  ("D. Dante Lorenso" <dante@lorenso.com>)
Responses Re: Is there a better way to do this?  ("D. Dante Lorenso" <dante@lorenso.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: Is there a better way to do this?
Next
From: Ben
Date:
Subject: Re: autovacuum not running