[Pdx-pm] (OT) SQL style question
publiustemp-pdxpm at yahoo.com
Thu Jan 13 14:02:06 PST 2005
Sorry for the OT question (well, it's not completely OT as this impacts
how Bricolage 2.0 will be implemented.)
We have views that reference more than one table. Our views have a
primary table they are based upon and fields from "non-primary tables."
To make it very clear which fields are which, there's been a bit of
discussion regarding how to make it visually distinct that a particular
field is from a table that is not the primary table of the view. Which
of the following is clearer?
Using double underscores to separate the other table name from its
Quoting column names and using periods as separators:
Is the latter portable? Is the former too confusing? Which is easier
to read? Are there reasonable alternatives?
Silence is Evil http://users.easystreet.com/ovid/philosophy/decency.html
Web Programming with Perl http://users.easystreet.com/ovid/cgi_course/
More information about the Pdx-pm-list