Re: [GENERAL] range type expression syntax

2015-02-27 Thread John Turner
l-ow...@postgresql.org [pgsql-general-ow...@postgresql.org]" im Auftrag von "John Turner [jjtur...@energi.com] Gesendet: Donnerstag, 26. Februar 2015 21:17 An: pgsql-general@postgresql.org Betreff: Re: [GENERAL] range type expression syntax On Thu, 26 Feb 2015 15:11:28 -0500, Jo

Re: [GENERAL] range type expression syntax

2015-02-26 Thread Marc Mamin
__ Von: pgsql-general-ow...@postgresql.org [pgsql-general-ow...@postgresql.org]" im Auftrag von "John Turner [jjtur...@energi.com] Gesendet: Donnerstag, 26. Februar 2015 21:17 An: pgsql-general@postgresql.org Betreff: Re: [GENERAL] range type expression syntax On Thu, 26 Feb 2015 15:11:28

Re: [GENERAL] range type expression syntax

2015-02-26 Thread John Turner
On Thu, 26 Feb 2015 15:11:28 -0500, John Turner 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]