bug report - Mailing list pgsql-bugs

From Chana Slutzkin
Subject bug report
Date
Msg-id Pine.BSI.4.05L.9911091219110.19849-100000@chaos.cs.huji.ac.il
Whole thread Raw
List pgsql-bugs
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:
---------------------------------------------------------------------








pgsql-bugs by date:

Previous
From: fredrik chabot
Date:
Subject: Possible bug in postgres || libpq
Next
From: Oliver Fischer
Date:
Subject: Re: [BUGS] No index support for date/time types?