Thread: bug report

bug report

From
Chana Slutzkin
Date:
Your name               :      Chana Slutzkin
Your email address      :      chana@cs.huji.ac.il

System Configuration
---------------------
  Architecture (example: Intel Pentium)         :   Intel Pentium

  Operating System (example: Linux 2.0.26 ELF)  :   BSD/OS-4.0

  PostgreSQL version (example: PostgreSQL-6.5.2):   PostgreSQL-6.5.2

  Compiler used (example:  gcc 2.8.0)           :   gcc 2.95

Please enter a FULL description of your problem:
------------------------------------------------
Regular expression search of type ^X*Y never matches

Please describe a way to repeat the problem.   Please try to provide a
concise reproducible example, if at all possible:
----------------------------------------------------------------------
"select * from users where id~'^0*12345678';"     does not match '12345678'
"select * from users where id~'0*12345678';"    matches '12345678'
"select * from users where id~'^12345678';"     matches '12345678'



If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------