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

Reply via email to