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

From D. Dante Lorenso
Subject Re: Is there a better way to do this?
Date
Msg-id 46D4A036.3070506@lorenso.com
Whole thread Raw
In response to Re: Is there a better way to do this?  (Michael Glaesemann <grzm@seespotcode.net>)
Responses Re: Is there a better way to do this?  (Michael Glaesemann <grzm@seespotcode.net>)
List pgsql-general
Michael Glaesemann wrote:
>
> 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.

Why?  Is this functionality expected to break in the future or has
unexpected side effects?  Is it less clear or less efficient?  Who
declared it bad practice and where can I read that documentation?

-- Dante

pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: Question regarding autovacuum
Next
From: Alvaro Herrera
Date:
Subject: Re: Out of Memory - 8.2.4