Re: [sqlite] splitting a line to produce several lines?

2011-09-12 Thread Black, Michael (IS)
: General Discussion of SQLite Database Subject: EXT :Re: [sqlite] splitting a line to produce several lines? On 12 sept. 2011, at 13:26, Black, Michael (IS) wrote: Since SQL is designed to return rows I believe the answer is "no" since you're data is not stored in rows. I suspe

Re: [sqlite] splitting a line to produce several lines?

2011-09-12 Thread Max Vlasov
On Mon, Sep 12, 2011 at 12:28 PM, Jean-Denis MUYS wrote: > > My question is: is there a pure SQL way to split the instances string, and > generate the instance lines from the instance list string? contrived example: > This kind of questions appear from time to time

Re: [sqlite] splitting a line to produce several lines?

2011-09-12 Thread Jean-Denis MUYS
m...@kleegroup.com>] Sent: Monday, September 12, 2011 3:28 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] splitting a line to produce several lines? I am migrating data from a database which has a table that describes items by "kinds". Instances of those "k

Re: [sqlite] splitting a line to produce several lines?

2011-09-12 Thread Black, Michael (IS)
t: Monday, September 12, 2011 3:28 AM To: General Discussion of SQLite Database Subject: EXT :[sqlite] splitting a line to produce several lines? I am migrating data from a database which has a table that describes items by "kinds". Instances of those "kinds" are stored in one col

[sqlite] splitting a line to produce several lines?

2011-09-12 Thread Jean-Denis MUYS
I am migrating data from a database which has a table that describes items by "kinds". Instances of those "kinds" are stored in one column of this table, listing each instance's id, with all ids separated by a slash "/". Of course, this is a very poor design. The target system has a proper