Re: Constraining overlapping date ranges - Mailing list pgsql-general

From Filip Rembiałkowski
Subject Re: Constraining overlapping date ranges
Date
Msg-id AANLkTimaJOrgYFn31kd7ju1QZ9Cszh=-Km1-3x3MF13-@mail.gmail.com
Whole thread Raw
In response to Re: Constraining overlapping date ranges  (Thomas Kellerer <spam_eater@gmx.net>)
List pgsql-general
2010/12/22 Thomas Kellerer <spam_eater@gmx.net>:

> I'm curious why you use this syntax as you have fixed values and could use
> the "standard" VALUES construct without problems:
>
> INSERT INTO tbl VALUES (1, '2010-01-01', '2010-12-31');

no particular reason; just two keystrokes less :-)

The SQL code is postgres-specific anyway.

pgsql-general by date:

Previous
From: Thomas Kellerer
Date:
Subject: Re: Constraining overlapping date ranges
Next
From: Tom Lane
Date:
Subject: Re: Table inheritance foreign key problem