[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