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: 20040630085425.A93096@megazone.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
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

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2004-06-30 15:56:58 Re: substring syntax with regexp
Previous Message Dennis Gearon 2004-06-30 15:52:21 backups