Demos · Guide · Class Reference · Wiki · Extensions · Live Chat
search

Yii Framework Forum: Postgresql Select Distinct On - Yii Framework Forum

Jump to content

Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

Postgresql Select Distinct On Allow set CDbCriteria->distinct property as string otherwise boole Rate Topic: -----

#1 User is offline   dponomarev 

  • Newbie
  • Yii
  • Group: Members
  • Posts: 2
  • Joined: 15-October 12
  • Location:Saint-Petersburg, Russia

Posted 14 February 2013 - 03:49 AM

At the bottom of the Chapter 7.3.3 "Select Lists" of the PostgreSQL manual 
DISTINCT ON
syntax is described. But when I want to use this syntax in 
CDbCriteria->distinct
- only boolean value available. And CDbCommandBuilder at line #123 of the yiiframework v1.1.13 for example, created statement SELECT DISTINCT, and no opportunity to hook this. Will be good to set CDbCriteria->distinct property as string or as array otherwise boolean as now. 
SELECT DISTINCT ON (expression [, expression ...]) select_list ...

Thanks!
0

Share this topic:


Page 1 of 1
  • You cannot start a new topic
  • You cannot reply to this topic

1 User(s) are reading this topic
0 members, 1 guests, 0 anonymous users