Re: New string functions; initdb required

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu>, Josh Berkus <josh(at)agliodbs(dot)com>
Cc: hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: New string functions; initdb required
Date: 2002-06-11 21:53:14
Message-ID: 3D06714A.688E98C8@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

> > How is SIMILAR TO different from ~ ?
> >From the part of Thomas's email you snipped:
> Implement SQL99 SIMILAR TO as a synonym for our existing operator "~".
> So the answer is "not at all"

Right. I'm not certain about the regex syntax defined by SQL99; I used
the syntax that we already have enabled and it looks like we have a
couple of other variants available if we need them. If someone wants to
research the *actual* syntax specified by SQL99 that would be good...

- Thomas

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2002-06-11 22:24:14 Schemas and template1
Previous Message Thomas Lockhart 2002-06-11 21:51:16 Re: New string functions; initdb required