[mythtv] Joining on a calculated column
Jeremiah Morris
jm at whpress.com
Mon Jan 10 22:13:29 EST 2005
On 10 Jan 2005, at 9:52 PM, David Engel wrote:
> Does that
> mean I'll have to replicate the calculation in all three places?
AFAIK, yes. User functions are only in the MySQL 5.x development. With
MySQL 4.1, you could use a sub-select to create a virtual table with
the calculation done once. With 3.x and 4.0, I think you're stuck doing
it the long way.
- Jer
More information about the mythtv-dev
mailing list