On 2015/11/24 9:20 PM, chromedout64 at yahoo.com wrote:
> Thanks for the reply. It would be the case of specifying a default value
> among other columns but not wishing to remove it from the inserted fields --
> not just because I'm lazy, but also to reuse that same INSERT statement for
> othe
Backward compatibility is an understandable concern, but since "DEFAULT" is one
of the 124 official SQLite keywords, you would expect it not to be used for
user-defined objects or else properly quoted.
http://www.sqlite.org/lang_keywords.html
Additionally, adding the capability of using a "DEFAU
On 2015/11/23 11:00 PM, chromedout64 at yahoo.com wrote:
> Maybe there's a technical reason that this functionality wasn't added to
> SQLite. Does anyone know?
I am not sure exactly what you intend with this.
Do you mean to Insert into a table a row with the default values? In
that case you c
Doesn't look like the formatting worked on the last one.
Just an quick example using the sqlite3 CLI:db=/tmp/test.dbsqlite3 $db "create
table t(id integer primary key,ts text default
(datetime('localtime','now')));"for x in "'no_date'" "'invalid_date'" "NULL"
"CURRENT_TIMESTAMP" "DEFAULT"; do?
Thanks for the reply. It would be the case of specifying a default value among
other columns but not wishing to remove it from the inserted fields -- not just
because I'm lazy, but also to reuse that same INSERT statement for other values.
Just an quick example using the sqlite3 CLI:db=/tmp/test.
On Mon, Nov 23, 2015 at 7:00 PM, wrote:
>
>
>
> Maybe there's a technical reason that this functionality wasn't added to
> SQLite. Does anyone know?
>
> ___
> sqlite-users mailing list
> sqlite-users at mailinglists.sqlite.org
> http://mailinglists.sql
Maybe there's a technical reason that this functionality wasn't added to
SQLite. Does anyone know?
It would be useful as a convenience, particularly on very?long?tables,?so the
user could omit all names and just use a single DEFAULT in the particular
value. It's also easier to programmatically decide whether to insert a DEFAULT,
NULL,?or an alternate value rather than selectively omitting a p
chromedout64 at yahoo.com wrote:
> Is it possible to implement a DEFAULT literal-value in SQLite, which
> would allow an individual column to be populated with a DEFAULT, similar
> to how a NULL or CURRENT_TIMESTAMP is currently used?
What is this needed for, when it is already possible to omit th
Is it possible to implement a DEFAULT literal-value in SQLite, which would
allow an individual column to be populated with a DEFAULT, similar to how a
NULL or CURRENT_TIMESTAMP is currently used? Thanks.
for example, from http://www.postgresql.org/docs/9.4/static/sql-insert.html
[ WITH [ RECURS
10 matches
Mail list logo