Subject | Re: [firebird-support] ansi sql92 and Firebird sql |
---|---|
Author | Martijn Tonies |
Post date | 2005-01-26T17:50:15Z |
Hello,
SQL-compliance comes in "levels". "Entry", "intermediate" and "full",
I believe. You don't need the below to be entry-level compliant.
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com
> Firebird1.5 is supposed to be compliant with SQL92, isn't it? If itTry wise-cracking someone else ;-)
SQL-compliance comes in "levels". "Entry", "intermediate" and "full",
I believe. You don't need the below to be entry-level compliant.
> does:Yes.
> 1. How can we explain that Firebird does not support the 'TRIM'
> function, ie TRIM([ [ LEADING | TRAILING | BOTH ] [character] FROM ]
> expr)?
> 2. For getting this function, is the only workaround the use of UDF
> (user defined functions)?
> 3. When will Firebird support the TRIM function, if it's not alreadyI'm unsure.
> in a latest release?
With regards,
Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com