On 2016-09-22 12:16 PM, Petite Abeille wrote:
On Sep 22, 2016, at 9:04 PM, Richard Hipp <d...@sqlite.org> wrote:
Ohhhhh! Row Values! Nice! :)
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