Re: array variables - Mailing list pgsql-sql

From Marcin Krawczyk
Subject Re: array variables
Date
Msg-id 95f6bf9b0811130113g60cfcbc6pf9a1aa10db82d3de@mail.gmail.com
Whole thread Raw
In response to array variables  ("Marcin Krawczyk" <jankes.mk@gmail.com>)
Responses Re: array variables
Re: array variables
List pgsql-sql
I know I can do one column like this : <br /><br />a := ARRAY(SELECT id FROM idx);<br /><br />but how about more than
one?<br />Because if I try this :<br /><br />a := ARRAY(SELECT id, p FROM idx);<br /><br />I get<br />ERROR: subquery
mustreturn only one column<br /> SQL state: 42601<br /><br />regards<br />mk<br /> 

pgsql-sql by date:

Previous
From: "Marcin Krawczyk"
Date:
Subject: array variables
Next
From: "Pavel Stehule"
Date:
Subject: Re: array variables