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

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 (view raw or flat)
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

pgsql-sql by date

Next:From: Kevin DuffyDate: 2008-09-05 21:33:46
Subject: Re: variables with SELECT statement
Previous:From: Tom LaneDate: 2008-09-05 21:26:59
Subject: Re: variables with SELECT statement

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