Re: variables with SELECT statement

From: "Kevin Duffy" <KD(at)wrinvestments(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>, "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>
Subject: Re: variables with SELECT statement
Date: 2008-09-05 21:50:21
Message-ID: DFC309C8A42633419600522FA8C4AE1A560F1B@mail-01.wrcapital.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

When was 8.3 released?

But for today I could do
string_to_array(regexp_replace(description, E'\\s+', ' '), ' ') as
desc

and get what I need to survive.

Many thanks for all the replys.
Would not have made progress on this by myself.

kd

-----Original Message-----
From: Scott Marlowe [mailto:scott(dot)marlowe(at)gmail(dot)com]
Sent: Friday, September 05, 2008 5:35 PM
To: Kevin Duffy
Cc: pgsql-sql(at)postgresql(dot)org; Frank Bax
Subject: Re: [SQL] variables with SELECT statement

On Fri, Sep 5, 2008 at 3:28 PM, Kevin Duffy <KD(at)wrinvestments(dot)com>
wrote:
> No looks like I have 8.2

I can attest that all of 8.3's performance improvements as well all of
the really useful new functions like the one mentioned here make it
well worth the effort to upgrade. I haven't been as excited about a
pgsql version since vacuum (regular) was invented.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Frank Bax 2008-09-05 21:55:35 Re: variables with SELECT statement
Previous Message Scott Marlowe 2008-09-05 21:34:32 Re: variables with SELECT statement