Re: [Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases

2018-12-17 Thread Carlos H. Cantu
>> Multi-row INSERTs - also marked as NO, but actually you can do insert >> from select in Firebird. MR> AFAIK, they mean insert with a values list (table value constructor) MR> instead of a single values set. Maybe... I based my answer on the "hint" displayed for that feature in the table. []s

Re: [Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases

2018-12-17 Thread Mark Rotteveel
On 17-12-2018 19:40, Carlos H. Cantu wrote: Seems that there are some incorrect information, ie: Duplicate NULL values in unique index - Firebird is marked as NO, but actually you can have several NULL keys in a Unique index contraint (not in PK). Multi-row INSERTs - also marked as NO, but a

Re: [Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases

2018-12-17 Thread Carlos H. Cantu
Title: Re: [Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases Seems that there are some incorrect information, ie: Duplicate NULL values in unique index - Firebird is marked as NO, but actually you can have several NULL keys in a Unique index contra

Re: [Firebird-devel] Support for RETURNING *?

2018-12-17 Thread Mark Rotteveel
On 17-12-2018 13:26, Adriano dos Santos Fernandes wrote: On 09/12/2018 11:55, Mark Rotteveel wrote: Back in 2012 I created CORE-3808 to request support for RETURNING *, which should - equivalent to SELECT * - return all columns instead of having to manually include all columns in the returning c

[Firebird-devel] Comparison of many standard (and non-standard) SQL features amongst 10 databases

2018-12-17 Thread marius adrian popa
Last updated: 2018-11-06 http://www.sql-workbench.eu/dbms_comparison.html Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel

Re: [Firebird-devel] Support for RETURNING *?

2018-12-17 Thread Adriano dos Santos Fernandes
On 09/12/2018 11:55, Mark Rotteveel wrote: > Back in 2012 I created CORE-3808 to request support for RETURNING *, > which should - equivalent to SELECT * - return all columns instead of > having to manually include all columns in the returning clause. > > The primary use case for me would be to mo