Re: Feedback about Drupal SQL debugging

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: Feedback about Drupal SQL debugging
Дата
Msg-id 4A8F2750.1010504@dunslane.net
обсуждение исходный текст
Ответ на Re: Feedback about Drupal SQL debugging  (Jean-Michel Pouré <jm@poure.com>)
Ответы Re: Feedback about Drupal SQL debugging  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: Feedback about Drupal SQL debugging  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers

Jean-Michel Pouré wrote:
>   
>> BTW, why don't we have a multi-argument version of CONCAT()?  In 8.4,
>> it
>> would be possible ... I should add it to mysqlcompat library.
>>     
>
> yes. In PostgreSQL core ...
>   

No.  That is exactly where it shouldn't go. And frankly, Drupal 
developers should stop writing non-portable code. Isn't there a Mysql 
mode that is supposed to conform to the standard, at least more than 
their default mode?

> PostgreSQL requires all non-aggregated fields to be present in the GROUP
> BY clause (I fixed 10 such issues in Drupal code).
> http://drupal.org/node/555530
>
> Why can't PostgreSQL add the required field automatically? Could this be
> added to PostgreSQL to-do-list?
>
>
>   

Isn't that contrary to the standard?

cheers

andrew


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Petr Jelinek
Дата:
Сообщение: Re: GRANT ON ALL IN schema
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Feedback about Drupal SQL debugging