"Brian Ceccarelli" writes:
> since the < and > comparison operators seem to be case insensitive:
They are not, unless you have managed to find a case-insensitive locale
somewhere. In any case we would not think that 'a' = 'A'.
regards, tom lane
--
Sent via pgsql-bugs m
> Description: Optimizer does not use function-based index for an order
> by
> Details:
>
> Subject line says it all.
The optimizer makes an educated guess about whether to use indexes or
not. Without more information it's impossible to second-guess it.
You might want to ask on pgsql-gener
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:
Subje
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 true, but should be false . . .
Detai
Yes... Described in "38.4. Expressions"...
To be more exact, it's neither bug nor feature. To evaluate an integral CASE
... END expression, the 'main' SQL engine needs all its parameters passed to
exist at least. But the evaluation rules (I think) remain the same both in
separate SQL queries an
Hello
it's not bug, but feature.
>
> CREATE OR REPLACE FUNCTION trg_mytable_after()
> RETURNS trigger AS
> $BODY$
> BEGIN
> IF TG_OP = 'UPDATE' OR TG_OP = 'DELETE' THEN
> IF (CASE WHEN TG_OP = 'DELETE' THEN TRUE ELSE OLD.a <> NEW.a END) THEN
> RAISE NOTICE 'OK!';
> END IF;
> END IF
2009/8/20 Dmitry Samokhin :
>
> The following bug has been logged online:
>
> Bug reference: 4997
> Logged by: Dmitry Samokhin
> Email address: s...@mail.ru
> PostgreSQL version: 8.3.7
> Operating system: Windows 2003 Server
> Description: Expression evaluation rules
> D
The following bug has been logged online:
Bug reference: 4997
Logged by: Dmitry Samokhin
Email address: s...@mail.ru
PostgreSQL version: 8.3.7
Operating system: Windows 2003 Server
Description:Expression evaluation rules
Details:
As described in section "4.2.12. Exp
