rusi writes: > On Saturday, November 2, 2013 10:13:06 PM UTC+5:30, Denis McMahon wrote: > > On Sat, 02 Nov 2013 18:25:31 +0200, Nick the Gr33k wrote: > > > > I just want a mysql column type that can be eligible to store an > > > array of elements, a list that is, no need for having a seperate > > > extra table for that if we can have a column that can store a > > > list of values. > > > You'd better take that up with the mysql designers. > > That Codd... > Should have studied some computer science > > [Ive a vague feeling I am repeating myself...]
Date and Darwen think that SQL designers should have studied and implemented relational theory (Codd's database theory). This doesn't contradict you, of course - possibly Codd should have studied CS. Date and Darwen think also that structured values like sets and relations should be allowed in a database and supported by the query language. Maybe their work should be taken as what Codd might think today, while the implementors of SQL products go their own merry ways. I grepped through one SQL standard on the web once to see how it refers to relational theory. Every single occurrence of "relation" was a substring of "correlational value" or something like that. My take from that is that SQL doesn't even pretend to be an implementation of Codd's theory. Suppose a database allowed structured values like lists of strings, lists of numbers, or even lists of such lists and more. Then it would actually be a Python issue how best to support that database. -- https://mail.python.org/mailman/listinfo/python-list
