On 2016-09-22 12:16 PM, Petite Abeille wrote:
On Sep 22, 2016, at 9:04 PM, Richard Hipp <d...@sqlite.org> wrote:
(https://www.sqlite.org/draft/releaselog/3_15_0.html).
Ohhhhh! Row Values! Nice! :)
https://www.sqlite.org/draft/rowvalue.html
I second that, its a valuable feature to have.
The purist in me thinks it should also be possible to have rows with exactly 1
or zero elements also, not just 2+ as described above.
Syntactically, () could be a zero-element row, and distinguishing a
single-element row could be done with say a trailing comma; eg "(42,)" is a
single-element row while "(42)" is simply the value 42 since parens are also
used for forcing evaluation precedence of expressions.
-- Darren Duncan
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
