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?
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 |