Why is this allowed?

From: "Chuck McDevitt" <cmcdevitt(at)greenplum(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Why is this allowed?
Date: 2007-03-11 00:09:42
Message-ID: EB48EBF3B239E948AC1E3F3780CF8F8801D7842E@MI8NYCMAIL02.Mi8.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Why don't we have some kind of error check for people entering things
like INTERVAL '1' DAY in their query, since we don't handle it.

select now() =now() + interval '1' day;

?column?

----------

T

This seems scary... We allow something through and then ignore it?

"Interval '1 day'" or "interval '1 day' day " both work.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Gregory Stark 2007-03-11 00:40:29 Re: Why is this allowed?
Previous Message Tom Lane 2007-03-10 22:39:37 Re: Race condition in pg_database_size()