Re: [GENERAL] [Plproxy-users] A complex plproxy query

2009-01-22 Thread Igor Katson
Hannu Krosing wrote: On Thu, 2009-01-22 at 16:13 +0200, Hannu Krosing wrote: On Thu, 2009-01-22 at 15:10 +0300, Igor Katson wrote: Ok, thank you, guys. What is the best way to make an array out of a column? I didn't make up anything better then writing a function: CREATE OR REPLACE F

Re: [GENERAL] [Plproxy-users] A complex plproxy query

2009-01-22 Thread Hannu Krosing
On Thu, 2009-01-22 at 16:13 +0200, Hannu Krosing wrote: > On Thu, 2009-01-22 at 15:10 +0300, Igor Katson wrote: > > > Ok, thank you, guys. What is the best way to make an array out of a > > column? I didn't make up anything better then writing a function: > > > > CREATE OR REPLACE FUNCTION int_c

Re: [GENERAL] [Plproxy-users] A complex plproxy query

2009-01-22 Thread Igor Katson
Hannu Krosing wrote: On Thu, 2009-01-22 at 15:10 +0300, Igor Katson wrote: Ok, thank you, guys. What is the best way to make an array out of a column? I didn't make up anything better then writing a function: CREATE OR REPLACE FUNCTION int_column_to_array(query text) RETURNS int[] AS $$

Re: [GENERAL] [Plproxy-users] A complex plproxy query

2009-01-22 Thread Hannu Krosing
On Thu, 2009-01-22 at 15:10 +0300, Igor Katson wrote: > Ok, thank you, guys. What is the best way to make an array out of a > column? I didn't make up anything better then writing a function: > > CREATE OR REPLACE FUNCTION int_column_to_array(query text) RETURNS int[] > AS $$ > DECLARE >

Re: [GENERAL] [Plproxy-users] A complex plproxy query

2009-01-22 Thread Igor Katson
Marko Kreen wrote: On 1/22/09, Igor Katson wrote: Hannu Krosing wrote: > On Thu, 2009-01-22 at 02:33 +0300, Igor Katson wrote: > > >> So to say, give me the list of friends (not only their ID's, but all the >> needed columns!) of given individual, which are in a given group. That >> se

Re: [GENERAL] [Plproxy-users] A complex plproxy query

2009-01-22 Thread Marko Kreen
On 1/22/09, Igor Katson wrote: > Hannu Krosing wrote: > > On Thu, 2009-01-22 at 02:33 +0300, Igor Katson wrote: > > > > > >> So to say, give me the list of friends (not only their ID's, but all the > >> needed columns!) of given individual, which are in a given group. That > >> seems ok with

Re: [GENERAL] [Plproxy-users] A complex plproxy query

2009-01-22 Thread Igor Katson
Hannu Krosing wrote: On Thu, 2009-01-22 at 02:33 +0300, Igor Katson wrote: So to say, give me the list of friends (not only their ID's, but all the needed columns!) of given individual, which are in a given group. That seems ok without plproxy, but with using it, I can't imagine how can I

Re: [GENERAL] [Plproxy-users] A complex plproxy query

2009-01-21 Thread Hannu Krosing
On Thu, 2009-01-22 at 02:33 +0300, Igor Katson wrote: > So to say, give me the list of friends (not only their ID's, but all the > needed columns!) of given individual, which are in a given group. That > seems ok without plproxy, but with using it, I can't imagine how can I > form a nice query,