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

Re: substring syntax with regexp

From: Stephan Szabo <sszabo(at)megazone(dot)bigpanda(dot)com>
To: joseph speigle <joe(dot)speigle(at)jklh(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: substring syntax with regexp
Date: 2004-06-30 15:55:13
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
On Wed, 30 Jun 2004, joseph speigle wrote:

> main=> \e hostname.sql
> ERROR:  syntax error at or near "http" at character 290
> LINE 13:   newuri = substr(tempuri from 'http://[^/]*/.*');

You probably need to double those quotes ('') since it's inside
a quoted string (the function body).

In response to

pgsql-general by date

Next:From: Richard HuxtonDate: 2004-06-30 15:56:58
Subject: Re: substring syntax with regexp
Previous:From: Dennis GearonDate: 2004-06-30 15:52:21
Subject: backups

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