Re: [Firebird-devel] where is ':' valid in Firebird SQL?

2018-01-03 Thread Lionel Elie Mamane
On Wed, Jan 03, 2018 at 06:57:21AM +0100, Lionel Elie Mamane wrote: > Where is ':' a valid character in Firebird SQL? In particular, is it > ever valid outside of "-delimited identifiers and '-delimited > strings? Thanks everybody for your help. I see my idea was not realistic. After sleeping on

[Firebird-devel] [FB-Tracker] Created: (CORE-5693) EXTRACT(QUARTER FROM )

2018-01-03 Thread Kovalenko Dmitry (JIRA)
EXTRACT(QUARTER FROM ) -- Key: CORE-5693 URL: http://tracker.firebirdsql.org/browse/CORE-5693 Project: Firebird Core Issue Type: New Feature Components: Engine Affects Versions: 3.0.3 Reporter:

Re: [Firebird-devel] where is ':' valid in Firebird SQL?

2018-01-03 Thread Vlad Khorsun via Firebird-devel
03.01.2018 7:57, Lionel Elie Mamane wrote: I'd like to avoid completely parsing the SQL statement for that, mainly so that the SQL statement is not modified by the LibreOffice SQL parser (and in particular quoting keywords it doesn't know as identifiers). So I'm hoping to simply go through the

Re: [Firebird-devel] where is ':' valid in Firebird SQL?

2018-01-03 Thread Dmitry Yemanov
03.01.2018 08:57, Lionel Elie Mamane wrote: I'd like to avoid completely parsing the SQL statement for that, mainly so that the SQL statement is not modified by the LibreOffice SQL parser (and in particular quoting keywords it doesn't know as identifiers). So I'm hoping to simply go through the

Re: [Firebird-devel] where is ':' valid in Firebird SQL?

2018-01-03 Thread Adriano dos Santos Fernandes
On 03/01/2018 03:57, Lionel Elie Mamane wrote: > Hi, > > Where is ':' a valid character in Firebird SQL? In particular, is it > ever valid outside of "-delimited identifiers and '-delimited strings? > > Context: In the LibreOffice integration of Firebird, we would like to > allow users to use