Skip site navigation (1) Skip section navigation (2)

Re: SQL Question

From: "Vyacheslav Kalinin" <vka(at)mgcp(dot)com>
To: josh(dot)walusz(at)lightyeardt(dot)com
Cc: joshua(at)joshuaneil(dot)com, pgsql-novice(at)postgresql(dot)org
Subject: Re: SQL Question
Date: 2008-03-04 09:51:01
Message-ID: 9b1af80e0803040151u3812a825w3823e324cf695263@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
My fault, there was an excess parenthesis. Should be
SELECT array_to_string(
   array(SELECT jobcode FROM slrojobs WHERE ronum = '56890' ORDER BY jobnum)
, ', ')

In response to

pgsql-novice by date

Next:From: Markus StockerDate: 2008-03-04 14:53:32
Subject: Explain explained
Previous:From: Vyacheslav KalininDate: 2008-03-03 23:06:50
Subject: Re: SQL Question

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group