From: | Marc Mamin <M(dot)Mamin(at)intershop(dot)de> |
---|---|
To: | John Turner <jjturner(at)energi(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: range type expression syntax |
Date: | 2015-02-27 07:57:15 |
Message-ID: | B6F6FD62F2624C4C9916AC0175D56D8828B701DF@jenmbs01.ad.intershop.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
> postgres=# select concat('[', now()::date, ',', now()::date,
> ']')::daterange testrange;
There are range specific functions for this:
select daterange(now()::date, now()::date, '[]')
regards,
Marc Mamin
________________________________________
Von: pgsql-general-owner(at)postgresql(dot)org [pgsql-general-owner(at)postgresql(dot)org]" im Auftrag von "John Turner [jjturner(at)energi(dot)com]
Gesendet: Donnerstag, 26. Februar 2015 21:17
An: pgsql-general(at)postgresql(dot)org
Betreff: Re: [GENERAL] range type expression syntax
On Thu, 26 Feb 2015 15:11:28 -0500, John Turner <jjturner(at)energi(dot)com>
wrote:
> Seems I'm missing a trick trying to get rangetypes working:
>
> No problem building the string:
> select concat('''[', now()::date, ',', now()::date, ']''') testrange;
> testrange
> ---------------------------
> '[2015-02-26,2015-02-26]'
> (1 row)
>
> Bombed-out trying to turn this into a daterange:
> postgres=# select concat('''[', now()::date, ',', now()::date,
> ']''')::daterange testrange;
> ERROR: malformed range literal: "'[2015-02-26,2015-02-26]'"
> DETAIL: Missing left parenthesis or bracket.
>
> Is there a specific casting I need to apply in order to render a literal
> daterange from parameterized range elements?
>
> /john
>
>
Sorry - too quick to post, I realize there was no need to wrap the
expression in extra quotes:
postgres=# select concat('[', now()::date, ',', now()::date,
']')::daterange testrange;
testrange
-------------------------
[2015-02-26,2015-02-27)
(1 row)
--
Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
From | Date | Subject | |
---|---|---|---|
Next Message | Jim Nasby | 2015-02-27 08:34:40 | Re: how to do merge in postgres ("with upsert as" not supported) |
Previous Message | Vick Khera | 2015-02-27 02:54:03 | Re: Hex characters in COPY input |