Re: SELECT with regular pattern '~' delivers wrong output

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Fabio Nanni <f(dot)nanni(at)albourne(dot)com>
Cc: pgsql-bugs(at)postgresql(dot)org, pgsql-ports(at)postgresql(dot)org
Subject: Re: SELECT with regular pattern '~' delivers wrong output
Date: 2001-02-13 00:07:31
Message-ID: 24858.982022851@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs pgsql-ports

Fabio Nanni <f(dot)nanni(at)albourne(dot)com> writes:
> A SELECT with regular patterns (~) won't give you the right rows.

Turns out there were some portability problems with our regexp code
on Alphas (or anywhere else that sizeof(int) < sizeof(long)). I've
applied fixes to current CVS; they should be in tomorrow morning's
snapshot if you want to do more-extensive testing.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message jyoung 2001-02-13 09:54:16 Server process exited with status 139
Previous Message Stephan Szabo 2001-02-12 19:38:27 Re: Referencial integerity problem

Browse pgsql-ports by date

  From Date Subject
Next Message Eduardo Stern 2001-02-13 02:33:24 Locales on Cygwin
Previous Message Fred Yankowski 2001-02-12 21:43:50 Re: plPGsql and PostgreSQL 7.1beta4 in Cygwin doesn't work