Re: [Firebird-devel] Time zones

2018-05-01 Thread Mark Rotteveel
On 1-5-2018 16:21, Adriano dos Santos Fernandes wrote: On 01/05/2018 04:57, Mark Rotteveel wrote: (resending as they haven't appeared on the list yet) On 30-4-2018 04:50, Adriano dos Santos Fernandes wrote: So before migrate to v4, users can adjust their code using Firebird 3 and once upgraded

Re: [Firebird-devel] Time zones

2018-05-01 Thread Adriano dos Santos Fernandes
On 01/05/2018 11:19, Adriano dos Santos Fernandes wrote: > > Let's say first about TIMESTAMP. > Why this? Because TIME if more problematic. :) The standard (at least up to the 2013 drafts) does not talk about TZ regions, but only offsets. And a TIME with TZ region is problematic. Because ther

Re: [Firebird-devel] Time zones

2018-05-01 Thread Adriano dos Santos Fernandes
On 01/05/2018 04:57, Mark Rotteveel wrote: > (resending as they haven't appeared on the list yet) > > On 30-4-2018 04:50, Adriano dos Santos Fernandes wrote: >> So before migrate to v4, users can adjust their code using Firebird 3 >> and once upgraded there will be no problems. > > I also want to

Re: [Firebird-devel] Time zones

2018-05-01 Thread Adriano dos Santos Fernandes
On 01/05/2018 07:45, Vlad Khorsun wrote: > >> - Compatibility: >> >> It was been created four new datatypes: >> - TIME WITH TIME ZONE >> - TIMESTAMP WITH TIME ZONE >> - TIME WITHOUT TIME ZONE >> - TIMESTAMP WITHOUT TIME ZONE >> >> The old types (TIME and TIMESTAMP) resolves to the "WITHOUT" versio

[Firebird-devel] [FB-Tracker] Created: (CORE-5811) PSQL procedures need to be able to RETURN a blob as a blob_id (GDS_QUAD)

2018-05-01 Thread Ray Holme (JIRA)
PSQL procedures need to be able to RETURN a blob as a blob_id (GDS_QUAD) Key: CORE-5811 URL: http://tracker.firebirdsql.org/browse/CORE-5811 Project: Firebird Core Issu

[Firebird-devel] [FB-Tracker] Created: (CORE-5810) rdb$db_key cannot be used in psql with a char(8) as documented

2018-05-01 Thread Ray Holme (JIRA)
rdb$db_key cannot be used in psql with a char(8) as documented -- Key: CORE-5810 URL: http://tracker.firebirdsql.org/browse/CORE-5810 Project: Firebird Core Issue Type: Bug

Re: [Firebird-devel] Time zones

2018-05-01 Thread Dimitry Sibiryakov
01.05.2018 12:45, Vlad Khorsun wrote:   I'd add it into 2.5.9 also, as many users will upgrade from per-v3 versions.   BTW, we could (should ?) add more such forward-compatibility features into last release of 2.5 I'm not sure if adding new features into stable branches match project's rel

Re: [Firebird-devel] Time zones

2018-05-01 Thread Vlad Khorsun
30.04.2018 5:50, Adriano dos Santos Fernandes wrote: Hi! Time zones branch is almost feature complete. There is two important subjects left: - ICU in Windows - as I already said, it need to be upgraded and I would like it builded as the upstream does, i.e., with full data. It would be good if

Re: [Firebird-devel] Time zones

2018-05-01 Thread Mark Rotteveel
(resending as they haven't appeared on the list yet) On 30-4-2018 04:50, Adriano dos Santos Fernandes wrote: Time zones branch is almost feature complete. There is two important subjects left: - ICU in Windows - as I already said, it need to be upgraded and I would like it builded as the upstr

Re: [Firebird-devel] Time zones

2018-05-01 Thread Mark Rotteveel
(resending as they haven't appeared on the list yet) On 30-4-2018 04:50, Adriano dos Santos Fernandes wrote: So before migrate to v4, users can adjust their code using Firebird 3 and once upgraded there will be no problems. I also want to repeat my opinion that I think it is a bit too late in