2011/8/7 Stephan Beal <sgb...@googlemail.com>:
> Also keep in mind that sqlite3 tries, to a large degree, to be compatible
> with ANSI SQL, and (IN "A B C"), in the form you describe, is not
> ANSI-specified.
Yes, but in PostgreSQL (as example) we can create user-defined
function returns table
from the list. SQLite can't do it and is impossible to use user extension too.
P.S. Example for PostgreSQL:
select list2items('a b c');
CREATE OR REPLACE FUNCTION public.list2items(in_list text)
RETURNS SETOF text AS
$BODY$
SELECT lindex($1, s) FROM generate_series(0,llength($1)-1) AS s;
$BODY$
LANGUAGE 'sql' IMMUTABLE;
CREATE OR REPLACE FUNCTION public.lindex(list text, index int4)
RETURNS text AS
$BODY$
return [lindex $1 $2]
$BODY$
LANGUAGE 'pltcl' IMMUTABLE;
CREATE OR REPLACE FUNCTION public.llength(list text)
RETURNS int4 AS
$BODY$
return [llength $1]
$BODY$
LANGUAGE 'pltcl' IMMUTABLE;
--
Best regards, Alexey Pechnikov.
http://pechnikov.tel/
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
