Path

projects / org / ezproject2010 / ezrating / forum / general / patch for postgresql

Patch for PostgreSQL

You need to be logged in to post messages in the forums. New users may register here.

chl

Member since:
08 September 2008

Posts: 2

Monday 08 September 2008 4:42:03 am

Hello,
Thanks for this extension, it helped me quite a lot on my site.
Just one little catch, the 'AS' separator is still mandatory in a PostgreSQL Select statement, hence this little patch.

Also, if you have a few moments, could you explain me the
... AND o.published >= ALL (SELECT o1.published FROM...
in the same SQL query ?
For what I understand, it should always return the votes published after the latest revision of the object ? Because on PostgreSQL (again :), it returns only the last rate (but I may have been wrong somewhere)
My current site really was simple enough to just take all rates on an article but I'd like to understand in case I come accross something more elaborate :)

Thanks anyway !
Up

chl

Member since:
08 September 2008

Posts: 2

Tuesday 09 September 2008 2:49:14 am

Oopsies, I didn't see your last commits, so sorry for the annoyance.

Actually, my project is nearly at end but the client wants some AJAX for the rating so I may post another useless patch some time :)
Up

Kristof Coomans

Member since:
09 January 2008

Posts: 66

Tuesday 23 September 2008 5:00:42 am

The part

independent eZ Publish developer and service provider | http://blog.coomanskristof.be | http://ezpedia.org
Up

You need to be logged in to post messages in the forums. New users may register here.