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

Reply via email to