Morgan Tocker wrote:
HI!

SELECT * FROM t1 WHERE c1 IN ("alpha", "beta", "gamma", )

Some programming languages (python) already work this way,
very handy, try to belive.
Add PHP, many others IIRC

PHP introduced it for array() initializers somewhere in the 4.x days,
and exactly for the reason of eased code auto-generation ...
AFAIR one of the main arguments *for* it was that even C array
initializers support this

And so far i don't remember anyone running into trouble with
this in PHP. So even though it helps only a very few use cases
it didn't hurt anyone either.

OTOH most languages used for generating SQL on the fly should
support some equivalent of PHPs

   join(",", $some_container)

these days so that the issue of the trailing comma can easily
be worked around at the cost of populating $some_container
first?

So /me undecided here ... with a slight bias towards "no"

--
Hartmut Holzgraefe, MySQL Regional Support Manager, EMEA

Sun Microsystems GmbH, Sonnenallee 1, 85551 Kirchheim-Heimstetten
Amtsgericht Muenchen: HRB161028
Geschaeftsfuehrer: Thomas Schroeder, Wolfgang Engels, Dr. Roland Boemer
Vorsitzender des Aufsichtsrates: Martin Haering

_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to     : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help   : https://help.launchpad.net/ListHelp

Reply via email to