Re: variables with SELECT statement

From: "Kevin Duffy" <KD(at)wrinvestments(dot)com>
To: <pgsql-sql(at)postgresql(dot)org>
Cc: "Frank Bax" <fbax(at)sympatico(dot)ca>
Subject: Re: variables with SELECT statement
Date: 2008-09-05 21:28:01
Message-ID: DFC309C8A42633419600522FA8C4AE1A560F19@mail-01.wrcapital.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

No looks like I have 8.2

-----Original Message-----
From: pgsql-sql-owner(at)postgresql(dot)org
[mailto:pgsql-sql-owner(at)postgresql(dot)org] On Behalf Of Frank Bax
Sent: Friday, September 05, 2008 5:13 PM
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: [SQL] variables with SELECT statement

Kevin Duffy wrote:
> Just testing the regexp_string_to_array
>
> This SQL
> select description, regexp_string_to_array(description::text , E'\\s+'
)
> as optdesc, securitytype
> from xxxxxx where type = 'B' order by 1
>
> produced this error:
>
> ERROR: function regexp_string_to_array(text, text) does not exist
> SQL state: 42883
> Hint: No function matches the given name and argument types. You may
> need to add explicit type casts.
> Character: 21

Are you running 8.3?

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Kevin Duffy 2008-09-05 21:33:46 Re: variables with SELECT statement
Previous Message Tom Lane 2008-09-05 21:26:59 Re: variables with SELECT statement