Regular expressions syntax: is \ the escape character ?

From: Gabriel Fernandez <gabi(at)unica(dot)edu>
To: PostgreSQL-general <pgsql-general(at)postgreSQL(dot)org>
Subject: Regular expressions syntax: is \ the escape character ?
Date: 2000-03-03 19:04:50
Message-ID: 38C00CD1.14DFE13A@unica.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm using regular expressions in 6.5.3 version but i cannot find the
character to escape special caracters as ?, $, ^.

I've tried with \ but it doesn't works.

Example: i want to find the row with the value 'fisica?' and i do:

select title from libros where title ~* 'fisica\?' ;

but i also obtain rows with values: 'fisicamente' or 'fisicas'

What am i doing wrong ?

Thanks in advance.

Gabi :-)

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Charles Tassell 2000-03-03 19:06:17 Re: [GENERAL] Illegal use of aggregates or non-group column in target list
Previous Message Abdelkrim WAHHABI 2000-03-03 19:03:06 system crash