Re: Regression in 8.3? - Mailing list pgsql-general

From Karsten Hilbert
Subject Re: Regression in 8.3?
Date
Msg-id 20071112120734.GA4458@merkur.hilbert.loc
Whole thread Raw
In response to Regression in 8.3?  (Patric Bechtel <patric.bechtel@gmail.com>)
Responses Re: Regression in 8.3?  (Thomas Pundt <mlists@rp-online.de>)
Re: Regression in 8.3?  (Patric Bechtel <patric.bechtel@gmail.com>)
List pgsql-general
On Mon, Nov 12, 2007 at 12:46:58AM +0100, Patric Bechtel wrote:

> select * from bla where a like '8%'

Patrick, I'm not sure what you expect to come back:

8 ? 0.08 ?

8% of each of bla.a's values ?

do 7% or 9% count, too ? ("a like '8%'" seems to say "well,
about 8% of a, or close, anyways").

IOW, it is not entirely clear and thus the server forces us
to make a choice and not second-guess our intentions.

Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Verison 8.3 PL/pgSQL debugger Question
Next
From: Thomas Pundt
Date:
Subject: Re: Regression in 8.3?