On 12/31/12, François Beausoleil wrote:
>
> Le 2012-12-31 à 15:38, Robert James a écrit :
>
>> DISTINCT is a very simple solution!
>> But I have one problem: In addition to the FIRST fields, I also do
>> want some aggregate functions. More accurately, it would be:
>>
>> SELECT grouping_field, FIR
Am 31.12.2012 um 22:18 schrieb Adrian Klaver:
> On 12/31/2012 09:02 AM, Philipp Kraus wrote:
>>
>> Am 31.12.2012 um 15:54 schrieb Adrian Klaver:
>>
>>> On 12/31/2012 05:41 AM, Philipp Kraus wrote:
Am 31.12.2012 um 02:11 schrieb Adrian Klaver:
>>>
>
> Actually as of 9.
On 12/31/2012 09:02 AM, Philipp Kraus wrote:
Am 31.12.2012 um 15:54 schrieb Adrian Klaver:
On 12/31/2012 05:41 AM, Philipp Kraus wrote:
Am 31.12.2012 um 02:11 schrieb Adrian Klaver:
Actually as of 9.0 that is not strictly true:
http://www.postgresql.org/docs/9.2/interactive/sql-alterdef
Michael Arnold writes:
> The locale is the same on both machines: "en_SG.UTF-8"
> I've extracted the smallest set of code which still produces the
> error. Unfortunately its still more than 1000 lines of code, as
> without the thread and connection pools the error goes away. If only
> 1 thread
Le 2012-12-31 à 15:38, Robert James a écrit :
> DISTINCT is a very simple solution!
> But I have one problem: In addition to the FIRST fields, I also do
> want some aggregate functions. More accurately, it would be:
>
> SELECT grouping_field, FIRST(field_a), FIRST(field_b), SUM(field_x),
> MAX(
DISTINCT is a very simple solution!
But I have one problem: In addition to the FIRST fields, I also do
want some aggregate functions. More accurately, it would be:
SELECT grouping_field, FIRST(field_a), FIRST(field_b), SUM(field_x),
MAX(field_y)
...
How should I do that? Should I do two queries
Hello,
can I create on PG 9.1 or newer a trigger or something other, that runs a
function if a new user is added, changed, deleted to / on the database?
I have got a "usertable" which stores some additional user information (full
name, mail address, etc) and I would like to create default data
i
I would like to have two schemas:
MyDB.sales
MyDB.security
Users that have rights in sales schema should be able to
select/insert/update/delete. The same users must have rights to check
foreign keys against users table (but they are now allowed to execute
select on this table).
Is that possib
Am 31.12.2012 um 18:02 schrieb Philipp Kraus:
>
> Am 31.12.2012 um 15:54 schrieb Adrian Klaver:
>
>> On 12/31/2012 05:41 AM, Philipp Kraus wrote:
>>>
>>> Am 31.12.2012 um 02:11 schrieb Adrian Klaver:
>>>
>>
Actually as of 9.0 that is not strictly true:
http://www.postgresql.o
Am 31.12.2012 um 15:54 schrieb Adrian Klaver:
> On 12/31/2012 05:41 AM, Philipp Kraus wrote:
>>
>> Am 31.12.2012 um 02:11 schrieb Adrian Klaver:
>>
>
>>>
>>> Actually as of 9.0 that is not strictly true:
>>> http://www.postgresql.org/docs/9.2/interactive/sql-alterdefaultprivileges.html
>>
>>
Bryan Lee Nuse writes:
>> Now you're doubtless wondering why Postgres doesn't dodge this ambiguity
>> for you.
> This is exactly what I was wondering, of course. And I follow the reasoning
> behind why it cannot, at present. If Postgres can't ensure that the view
> definition is valid SQL, t
Jack Christensen writes:
> On 12/31/2012 8:33 AM, Robert James wrote:
>> SELECT grouping_field, FIRST(field_a), FIRST(field_b)
>> FROM ...
>> ORDER BY field_c DESC, field_d ASC, myfunc(field_e) ASC
>> GROUP BY grouping_field
>>
>> How can I do that with Postgres?
> select distinct on (grouping_f
On 12/31/2012 05:41 AM, Philipp Kraus wrote:
Am 31.12.2012 um 02:11 schrieb Adrian Klaver:
Actually as of 9.0 that is not strictly true:
http://www.postgresql.org/docs/9.2/interactive/sql-alterdefaultprivileges.html
I have create a view for access a table and rules for modifiy the based t
On 12/31/2012 8:33 AM, Robert James wrote:
I have a query
SELECT grouping_field, MIN(field_a), MIN(field_b)
FROM ...
GROUP BY grouping_field
But, instead of picking the MIN field_a and MIN field_b, I'd like to
pick field_a and field_b from the first record, according to an order
I'll s
I have a query
SELECT grouping_field, MIN(field_a), MIN(field_b)
FROM ...
GROUP BY grouping_field
But, instead of picking the MIN field_a and MIN field_b, I'd like to
pick field_a and field_b from the first record, according to an order
I'll specify. In pseudo-SQL, it would be something li
Am 31.12.2012 um 02:11 schrieb Adrian Klaver:
> On 12/30/2012 04:06 PM, Christian Hammers wrote:
>> Am Sun, 30 Dec 2012 15:54:32 +0100
>> schrieb Philipp Kraus :
>>
>>> Hello,
>>>
>>> can I set all rights to a schema and its content? I have different
>>> schema and in the public schema all user
Am 31.12.2012 um 02:11 schrieb Adrian Klaver:
> On 12/30/2012 04:06 PM, Christian Hammers wrote:
>> Am Sun, 30 Dec 2012 15:54:32 +0100
>> schrieb Philipp Kraus :
>>
>>> Hello,
>>>
>>> can I set all rights to a schema and its content? I have different
>>> schema and in the public schema all user
17 matches
Mail list logo
