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:
---------------------------------------------------------------------