Hello, On 2018-01-03 00:02, Tony Papadimitriou wrote:
MySQL does not seem to have a problem with it.
MySQL has a separator specified by a distinct clause. In SQLite it is specified by a second expression, which, in a canonical and intuitive point of view, is a constant string. However it can vary from record to record and can be used in many fancy and/or useful ways:
sqlite> WITH RECURSIVE numbers(n,p) AS (VALUES(random()/1000000000,0) UNION ALL SELECT random()/1000000000,n FROM numbers LIMIT 10) SELECT group_concat(n,substr('<=>',3*(n<p),3)) FROM numbers;
8566622672>2879787174<=7821300466>-9054357747<=3166199899>-4120363042<=8151009951>-7018229290<=4454709919<=8212308797 -- best regards Cezary H. Noweta _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users