How to add a current string into an already existing list

Jussi Piitulainen jpiitula at ling.helsinki.fi
Sat Nov 2 19:30:39 CET 2013


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.



More information about the Python-list mailing list