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

Re: variables with SELECT statement

From: Frank Bax <fbax(at)sympatico(dot)ca>
To:
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: variables with SELECT statement
Date: 2008-09-05 21:13:06
Message-ID: 48C1A0E2.30607@sympatico.ca (view raw or flat)
Thread:
Lists: 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?


In response to

Responses

pgsql-sql by date

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

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