Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: MythTV: Dev

pgsql support and group by clauses

 

 

MythTV dev RSS feed   Index | Next | Previous | View Threaded


fvilas at iname

Aug 6, 2005, 8:41 AM

Post #1 of 1 (412 views)
Permalink
pgsql support and group by clauses

After several weeks since my last post about this, I think I have most of the db backend configured to handle different databases. Right now there is only support for MySQL and PostgreSQL (alpha support), but the functions are designed to be extensible to any other db supported by Qt. I am running through the final (I hope) stages of testing this, so hopefully I'll be able to submit a patch later this weekend.

On a somewhat related note, there are many "group by" clauses in select statements that don't use any aggregate functions. I am not sure what the intent is, so I don't want to remove them. However using "group by" without aggregate functions is non-standard and therefore not very portable. I have so far not seen any ill effects from commenting them out, but I'm not exactly a MySQL expert. Any guidance here would be greatly appreciated.

--
Thanks,
Fernando Vilas
fvilas[at]iname.com

MythTV dev RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact lists@gossamer-threads.com
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.