Re: variables with SELECT statement - Mailing list pgsql-sql

From Frank Bax
Subject Re: variables with SELECT statement
Date
Msg-id 48C1A0E2.30607@sympatico.ca
Whole thread Raw
In response to Re: variables with SELECT statement  ("Kevin Duffy" <KD@wrinvestments.com>)
Responses Re: variables with SELECT statement  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: variables with SELECT statement  ("Kevin Duffy" <KD@wrinvestments.com>)
List pgsql-sql
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?



pgsql-sql by date:

Previous
From: "Kevin Duffy"
Date:
Subject: Re: variables with SELECT statement
Next
From: Tom Lane
Date:
Subject: Re: variables with SELECT statement