than even an inline query?
Please show me an example where an inline query gets a performance boost.
Thanks!
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Wednesday, August 11, 2010 4:34 PM
To: Brian Ceccarelli
Cc: Robert Haas; pgsql-bugs@postgresql.org
Subject:
mailto:robertmh...@gmail.com]
Sent: Wednesday, August 11, 2010 11:33 AM
To: Brian Ceccarelli
Cc: Tom Lane; pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #5611: SQL Function STABLE promoting to VOLATILE
On Wed, Aug 11, 2010 at 11:01 AM, Brian Ceccarelli
wrote:
> My complaint
and (pp.months_of_year & (1 << (extract(month from now_w at time zone
t.name)::int4))) <> 0
group by pp.vp_id, pp.ver_id, pp.pm_id, pp.pp_min_qty;
return;
end;
$BODY$
language 'plpgsql' STABLE
rows 1000;
But that is not all that's going on. It tur
The following bug has been logged online:
Bug reference: 5611
Logged by: Brian Ceccarelli
Email address: bceccare...@net32.com
PostgreSQL version: 8.4.4
Operating system: Windows XP 32 bit and Red Hat 5.4 64 bit
Description:SQL Function STABLE promoting to VOLATILE
th strings where the
letters become different.
It is a combination of both case-sensitive and case-insenstive. Completely
bogus.It does not matter what computer I am using.I get the same
bogus behavior on all my operating systems and Postgres versions.
Brian Ceccarelli
Talus Software
4
, August 24, 2009 4:54 AM
To: Brian Ceccarelli
Cc: pgsql-bugs@postgresql.org
Subject: Re: [BUGS] BUG #4999: select 'a' < 'A' is true, but should be false
. . .
On tor, 2009-08-20 at 20:24 +, Brian Ceccarelli wrote:
> since the < and > comparison operators seem to
The following bug has been logged online:
Bug reference: 5000
Logged by: Brian Ceccarelli
Email address: cecca...@talusmusic.com
PostgreSQL version: 8.2.13
Operating system: Linux
Description:Optimizer does not use function-based index for an order
by
Details
The following bug has been logged online:
Bug reference: 4999
Logged by: Brian Ceccarelli
Email address: cecca...@talussoftware.com
PostgreSQL version: 8.4.0 to 8.2.13
Operating system: Linux and XP
Description:select 'a' < 'A' is tr
The following bug has been logged online:
Bug reference: 4911
Logged by: Brian Ceccarelli
Email address: cecca...@talussoftware.com
PostgreSQL version: 8.4
Operating system: Windows, Linux
Description:Cannot assign a value to a member of a nested composite
type
