[plug] Re: [OT] SQL column splitting

[James Devenish]

In message <1100520485.3197.11.camel at latte.internal.itmaze.com.au>
on Mon, Nov 15, 2004 at 08:08:05PM +0800, Onno Benschop wrote:
> Depending on how "dirty" the data is, you could define the field that
> contains the "x,y, z" as an enumerated field and select based on
> enumField+0, which returns the internal storage format.

I'm not sure if I understand your gist correctly, but perhaps I can
make a relevant comment: 'x', 'y' and ' z' are arbitrary unpredictable
strings delimited by commas, so the enumeration couldn't be constructed
without parsing the strings in the first place (i.e. back to the
original problem).