Re: Constraining overlapping date ranges

From: Filip Rembiałkowski <filip(dot)rembialkowski(at)gmail(dot)com>
To: Thomas Kellerer <spam_eater(at)gmx(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Constraining overlapping date ranges
Date: 2010-12-22 14:04:02
Message-ID: AANLkTimaJOrgYFn31kd7ju1QZ9Cszh=-Km1-3x3MF13-@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2010/12/22 Thomas Kellerer <spam_eater(at)gmx(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2010-12-22 14:37:20 Re: Table inheritance foreign key problem
Previous Message Thomas Kellerer 2010-12-22 13:42:35 Re: Constraining overlapping date ranges