[Pdx-pm] (OT) SQL style question

Ovid publiustemp-pdxpm at yahoo.com
Thu Jan 13 14:02:06 PST 2005

Hi all,

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
field name:

  SELECT id, 
  FROM   some_view

Quoting column names and using periods as separators:

  SELECT "id", 
  FROM   some_view

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
Ovid                       http://www.perlmonks.org/index.pl?node_id=17000
Web Programming with Perl  http://users.easystreet.com/ovid/cgi_course/

More information about the Pdx-pm-list mailing list