Re: [SQL] Sorting items in aggregate function

Steven Murdoch escreveu: I would like to concatenate sorted strings in an aggregate function. I found a way to do it without sorting[1], but not with. Here is an example of a setup and what I could like to achieve. Does anyone have suggestions on what is the best way to get the desired result?

Re: [SQL] Sorting items in aggregate function

Michael Fuhr <[EMAIL PROTECTED]> writes: > On Tue, Sep 12, 2006 at 04:46:28PM +0100, Steven Murdoch wrote: >> Here is an example of a setup and what I could like to achieve. Does >> anyone have suggestions on what is the best way to get the desired >> result? > Use the aggregate over an ordered su

[SQL] How to get all users under a group

Hello, I know \du+ can get all group info for each user. Could someone tell me how to get all users under each group please? such as provide the group name, showing all users under the group. Thanks, Emi ---(end of broadcast)--- TIP 5: don't fo

Re: [SQL] Two optimization questions

Aaron Bono wrote: You could split it into sub-queries but would that make the performance better or worse? I guess it depends on how much data is there, and what frequency you have ot the event_type's but indexing the event_type column would help. This may be worth a try - use EXPLAIN to see

Re: [SQL] Two optimization questions

On 9/12/06, Mezei Zoltán <[EMAIL PROTECTED]> wrote: Hi,I think it can be done better than I did and I want to learn...1. I have a table that registers the history of messages:output_message_history(id, event_type, event_time)I need those ID-s from the table where there is one 'MESSAGE SENT' event a

Re: [SQL] Sorting items in aggregate function

On Sep 12 04:46, Steven Murdoch wrote: > I would like to concatenate sorted strings in an aggregate function. I > found a way to do it without sorting[1], but not with. If the array elements will be made of integers, then you can use sort() procedure comes with intarray contrib module. For instanc

Re: [SQL] on connect/on disconnect

On 9/11/06, Robert Edwards <[EMAIL PROTECTED]> wrote: Markus Schaber wrote:> Hi, Robert,>> Robert Edwards wrote:>>>(this is my first post to this list...)>>> Welcome here. :-)I am wondering if Postgres, and/or SQL in general, has a facility to >>run a function at connection set-up time (after a

Re: [SQL] Sorting items in aggregate function

On Tue, Sep 12, 2006 at 04:46:28PM +0100, Steven Murdoch wrote: > Here is an example of a setup and what I could like to achieve. Does > anyone have suggestions on what is the best way to get the desired > result? Use the aggregate over an ordered subquery: SELECT name, trim(concat(code || ' '))

Re: [SQL] Joint a table back on itself?

On 9/12/06 11:55 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote: > Hi all, > > I have a union query that generates a table with > directional measurments (a=azimuth, i=depth) at > various depths (md) down a hole. The results look > like: > hole_id | md | a| i|e >

[SQL] Sorting items in aggregate function

I would like to concatenate sorted strings in an aggregate function. I found a way to do it without sorting[1], but not with. Here is an example of a setup and what I could like to achieve. Does anyone have suggestions on what is the best way to get the desired result? Thanks, Steven. CREATE TAB

[SQL] Joint a table back on itself?

Hi all, I have a union query that generates a table with directional measurments (a=azimuth, i=depth) at various depths (md) down a hole. The results look like: hole_id | md | a| i|e |n |v ---++++--

[SQL] Two optimization questions

Hi, I think it can be done better than I did and I want to learn... 1. I have a table that registers the history of messages: output_message_history(id, event_type, event_time) I need those ID-s from the table where there is one 'MESSAGE SENT' event and one 'MESSAGE SUBMITTED' event and there