How to enter daterange into a raw?

From: Csanyi Pal <csanyipal(at)gmail(dot)com>
To: pgadmin-support(at)postgresql(dot)org
Subject: How to enter daterange into a raw?
Date: 2013-07-31 18:24:57
Message-ID: 20130731182457.GB6958@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

Hi,

I have installed PostgreSQL 9.2 on my desktop machine, and
pgAdmin III version: 1.16.1.

I'm being creating a new database with daterange type.

When I'm trying to enter in the 'Edit Data - PostgreSQL' window in the
first raw a range of data:

'2013-09-01, 2013-11-01' without quotes, I get error message:
ERROR: array value must start with "{" or dimension information
LINE 1: INSERT INTO public.negyedev(ettol_eddig) VALUES ('2013-09-01...
^
I want inclusive start and end bounds.

Well, I dont know how to enter the start data and the end data of the
range in pgAdmin III?

--
Regards from Pal

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message David Johnston 2013-07-31 21:36:23 Re: How to enter daterange into a raw?
Previous Message Ashesh Vashi 2013-07-26 08:59:13 Re: pgAdmin - crashes when connection is lost.