From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Jean-Michel Pouré <jm(at)poure(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Feedback about Drupal SQL debugging |
Date: | 2009-08-21 23:01:36 |
Message-ID: | 4A8F2750.1010504@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
From | Date | Subject | |
---|---|---|---|
Next Message | Greg Stark | 2009-08-21 23:03:40 | Re: Feedback about Drupal SQL debugging |
Previous Message | Petr Jelinek | 2009-08-21 22:51:00 | Re: GRANT ON ALL IN schema |