> -----Original Message----- > From: Darren Duncan [mailto:[EMAIL PROTECTED] > Sent: Friday, February 18, 2005 1:54 PM > To: sqlite-users@sqlite.org > Subject: SPAM Re: [sqlite] Feature request > > At 11:20 AM -0700 2/18/05, Robert Simpson wrote: > >PRAGMA real_column_names=0|1 > > > >Usage: > >For a given SELECT clause, enabling this pragma causes the > column names > >generated in the resultset (provided they are of TK_COLUMN > type) to be > >returned in dotted form as either TableName.ColumnName or > >Database.TableName.ColumnName in the case of an attached > database. Any > >alias names are ignored unless they are for an unbound or > calculated column > >in the resultset. > > > >Reason: > >Enabling this pragma will give database driver implementers > (like me) the > >ability to extract better and more robust schema information > gleaned from an > >arbitrary SELECT clause. > > This solution sounds like a cludge to me, that would only work with > some select statements. I would prefer a solution that works with > all select statements of arbitrary complexity. > > That said, the beauty of your "80% solution", aside from having a > small code footprint, is that it seems to have no effect on anyone > who doesn't reference your pragma.
It's no more of a cludge than full_column_names, and is much more useful. When you say "only works with some select statements" -- can you think of any that this pragma will not work on? Lets ignore views entirely, as the pragma is supposed to be a more useful replacement of "full_column_names" and therefore does no additional magic above what "full_column_names" did. Robert
