| From: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>, Brendan Jurd <direvus(at)gmail(dot)com>, Kevin Grittner <Kevin(dot)Grittner(at)wicourts(dot)gov>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle |
| Date: | 2008-11-08 19:44:27 |
| Message-ID: | 4915EC1B.7040206@cheapcomplexdevices.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com> writes:
>> Tom Lane wrote:
>>> The trouble is that older servers will (by default) report
>>> an error on that line and keep right on chugging.
>
>> Not necessarily. Couldn't we put
>
>> select * from (select substring(version() from '[0-9\.]+') as version) as a
>> join (select generate_series(0,100000000000)) as b on(version<'8.4');
>> set intervalstyle = something;
>
> [ shrug... ] It's still just one easily missable bleat.
Not here.
On my system it hangs forever on 8.3 or less and proceeds
harmlessly with 8.4.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-11-08 19:47:26 | Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle |
| Previous Message | Tom Lane | 2008-11-08 19:42:26 | Re: Patch for SQL-Standard Interval output and decoupling DateStyle from IntervalStyle |