Обсуждение: ~* operator

Поиск
Список
Период
Сортировка

~* operator

От
"Christopher Kings-Lynne"
Дата:
Hi guys,

Where can I find a list of all the 'special' characters in the ~* operator?

Thanks,

Chris



Re: ~* operator

От
Czuczy Gergely
Дата:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

hello

take a look at the HTML docs(found in postgres.tar.gz, in the source
tarball), and see functions-matching.html


Bye,

Gergely Czuczy
mailto: phoemix@harmless.hu
PGP pubkey: http://phoemix.harmless.hu/phoemix.pgp
iRCNet: #demoscene   ICQ: 8067175

The point is, that geeks are not necessarily the outcasts
society often believes they are. The fact is that society
isn't cool enough to be included in our activities.

On Wed, 3 Sep 2003, Christopher Kings-Lynne wrote:

> Hi guys,
>
> Where can I find a list of all the 'special' characters in the ~* operator?
>
> Thanks,
>
> Chris
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
>
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE/VXw3bBsEN0U7BV0RAmlaAKDvavllEtn84LNx+C+/ejh5lmu2cgCg19P0
et9sL60XPEUdb01raCFYtYQ=
=lu3K
-----END PGP SIGNATURE-----




Re: ~* operator

От
Alvaro Herrera Munoz
Дата:
On Wed, Sep 03, 2003 at 01:28:16PM +0800, Christopher Kings-Lynne wrote:
> Hi guys,
> 
> Where can I find a list of all the 'special' characters in the ~* operator?

They are the same for the ~ operator, and should be listed at the reference page
for regular expressions...

http://developer.postgresql.org/docs/postgres/functions-matching.html#FUNCTIONS-POSIX-REGEXP

Note that those are probably a little different from previous releases because
the regex engine has been changed.

-- 
Alvaro Herrera (<alvherre[@]dcc.uchile.cl>)
"I dream about dreams about dreams", sang the nightingale
under the pale moon (Sandman)