SQLite Forum

'values' with no args : has to be syntax error?
Login
All things being equal - is there a reason why the no-arg version of 'values' isn't allowed?

This is just an academic question : no serious issue here - just one of consistency. (I'm writing a guide - and for that it is useful to show minimal examples).

The following will give exactly one row:

```
values(1)
```

Which is the exact equivalent of:

```
select 1
```

However; the next example is syntax error:

```
values()
```

But arguably should be the exact equivalent of:

```
select 1 where 0
```