Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

BUG #3788: POSIX regexp seems doesn't work for '(?!re) ' pattern



The following bug has been logged online:

Bug reference:      3788
Logged by:          Vitaly
Email address:      vitaly(dot)yakunin(at)gmail(dot)com
PostgreSQL version: 8.3-beta3
Operating system:   WinXP
Description:        POSIX regexp seems doesn't work for '(?!re) ' pattern
Details: 

SELECT author, type
  FROM books WHERE "type" ~ '(?!novel)'; 

This select work incorrect. It returns all types. 

Work around:
SELECT author, type
  FROM books WHERE not ("type" ~ '(?=novel)');



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group