Home > mailing lists

Re: substring syntax with regexp - Mailing list pgsql-general

From	Stephan Szabo
Subject	Re: substring syntax with regexp
Date	June 30, 2004 15:56:55
Msg-id	20040630085425.A93096@megazone.bigpanda.com Whole thread Raw
In response to	substring syntax with regexp (joseph speigle <joe.speigle@jklh.us>)
List	pgsql-general

Tree view

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).

pgsql-general by date:

From: Alvaro Herrera
Date: 30 June 2004, 15:46:15
Subject: Re: substring syntax with regexp

From: Eric Wright
Date: 30 June 2004, 15:57:07
Subject: Re: postgresql install: jdbc: No such file or directory.

Re: substring syntax with regexp - Mailing list pgsql-general

Previous

Next