Re: TIP#308 Published: Tcl Database Connectivity (TDBC)

Hi,

Kevin Kenny wrote :

Eric Hassold, Twylite, and Wojciech Kocjan all request that rows from
a database query all be returned as lists.

Actually, I was only pointing out a possible flaw, and commenting about this so-called "abominable" feature being quite usual. I find dict elegant approach, but this has to be addressed. On the other side, rows as list + method to retrieve null fields is more generic. So I really have no definitive opinion (except maybe supporting both?)


tom.rmadilo wrote :

Of course, explicit column naming with 'AS' would be recommended. But to
answer your question/comment "which RDBMS supports that abdominal
feature?, I would say most if not all.


Actually _EVERY_ RDBMS supports this feature. What none of the RDBMS's
support is ordered storage of data on disk (that is why you have order-
by, and should avoid select *). So, if you didn't enforce the ordering
of columns on select, you couldn't SELECT into a table using a select
statement.


I find my way to formulate answer, without uppercases and emphasis, more gentle and adequate on a public forum. And, to be accurate, I was explicitly commenting on "RDBMS supporting multiple columns having same name" (not on rows being ordered), so "every" doesn't apply here. See e.g. MS Access:

SELECT 1 AS a, 2 AS a FROM Customers;
ERREUR: Alias de sortie 'a' repliqué

yes, my Access version is localized. Something like:
ERROR: duplicate output alias 'a'


Eric


.

Relevant Pages

  • Re: three of the Cloverfield features fit for Tcl?
    ... that "#{" was too likely to occur in innocent ... Inside lists? ... that's not commenting but proactive obfuscation. ...
    (comp.lang.tcl)
  • Re: 10 Best Things Ever on TV
    ... I've been commenting on others' lists, but never tried to come up with a ... The Ernie Kovacs show ... You can't reason with someone whose first line of argument is ...
    (rec.arts.tv)
  • Re: Autorun is VERY bad
    ... from other lists and is praised for its userfriendly way of supporting ... patience when some off-the-wall question would require ... ..the Sin of Ignorance, ...
    (Ubuntu)
  • Re: Newbie: VBScripting & IIS (4.0)
    ... > I am new to supporting an environment with mostly NT40/IIS40 servers. ... > trying to find a resource that provides all the objects used by IIS 4.0 ... > lists the objects, properties and methods. ... access to really old MSDN CDs, I don't know of a list for IIS4 only. ...
    (microsoft.public.windows.server.scripting)
  • Re: Dems bitch as New Orleans drowns
    ... >>obviously right so there can't be any good reason to disagree with me, ... > Actually, _two_ examples, considering Joe's response to Andrew. ... Joe was commenting on a particular post by a particular poster. ... commenting on everyone still supporting the Bush administration. ...
    (rec.arts.sf.fandom)