Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Is there a better way to do this?
- From: "D. Dante Lorenso" <dante(at)lorenso(dot)com>
- To: Michael Glaesemann <grzm(at)seespotcode(dot)net>
- 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: Tue, 28 Aug 2007 17:22:46 -0500
Michael Glaesemann wrote:
On Aug 28, 2007, at 16:55 , D. Dante Lorenso wrote:It's bad practice to concatenate like this. Use time + days * interval '1 day' and be done with it.RETURN time + (days || ' days')::INTERVAL;
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
- Follow-Ups:
- Re: Is there a better way to do this?
- From: Michael Glaesemann
- Re: Is there a better way to do this?
- References:
- Is there a better way to do this?
- From: Wei Weng
- Re: Is there a better way to do this?
- From: D. Dante Lorenso
- Re: Is there a better way to do this?
- From: Michael Glaesemann
- Is there a better way to do this?
- Prev by Date: Re: Question regarding autovacuum
- Next by Date: Re: Out of Memory - 8.2.4
- Previous by thread: Re: Is there a better way to do this?
- Next by thread: Re: Is there a better way to do this?
- Indexes: