David Burgess wrote:
>> Where do the quotes around the value come from?
>
> I typed them. Simgle set of double quotes
I meant the quotes around the entire value returned by the SELECT.
>> Are you using the standard command-line shell, and which output mode?
>
> yes and the default mode
The default mode would not output the column name.
And it works for me:
sqlite> create table sql_procs(name,sql);
sqlite> insert into sql_procs (name, sql) values ('a', edit('sql','vim'));
sqlite> select sql from sql_procs where name = 'a';
select * from "mytable" ;
sqlite>
Regards,
Clemens
_______________________________________________
sqlite-users mailing list
[email protected]
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
