ôÕÔ ÏÂÎÁÒÕÖÉÌÁÓØ ÐÒÏÂÌÅÍÁ Ó FB2 RC1.
åÓÌÉ ÓÏÚÄÁÔØ ÓÌÅÄÕÀÝÕÀ ÔÁÂÌÉÃÕ Ó ÐÅÒ×ÉÞÎÙÍ ËÌÀÞÏÍ É ÚÁÐÏÌÎÉÔØ ÅÅ ÄÁÎÎÙÍÉ:
CREATE TABLE SG_T_PARAM (
ARG_VALUE NUMERIC(15,3) NOT NULL,
RES_VALUE NUMERIC(15,3) NOT NULL,
ARG_NAME VARCHAR(2) NOT NULL
);
ALTER TABLE SG_T_PARAM ADD CONSTRAINT PK_SG_T_PARAM PRIMARY KEY (ARG_NAME,
ARG_VALUE);
INSERT INTO SG_T_PARAM (ARG_VALUE, RES_VALUE, ARG_NAME) VALUES (3, 0, 'H');
INSERT INTO SG_T_PARAM (ARG_VALUE, RES_VALUE, ARG_NAME) VALUES (4, 0.01,
'H');
INSERT INTO SG_T_PARAM (ARG_VALUE, RES_VALUE, ARG_NAME) VALUES (5, 0.02,
'H');
INSERT INTO SG_T_PARAM (ARG_VALUE, RES_VALUE, ARG_NAME) VALUES (6, 0.03,
'H');
INSERT INTO SG_T_PARAM (ARG_VALUE, RES_VALUE, ARG_NAME) VALUES (7, 0.04,
'H');
commit;
ðÏÓÌÅ ÐÏÐÙÔÁÔØÓÑ ×ÙÐÏÌÎÉÔØ ÚÁÐÒÏÓ:
select *
from SG_T_Param A
where A.Arg_Name = 'H' and A.Arg_Value > cast(4.5 as double precision)
ÔÏ ÏÎ ×ÏÚ×ÒÁÔÉÔ Ó ÐÌÁÎÏÍ ÐÏ-ÕÍÏÌÞÁÎÉÀ 2 ÚÁÐÉÓÉ, Á Ó ÐÌÁÎÏÍ - plan(A
natural) - ÔÒÉ (ÜÔÏ ÐÒÁ×ÉÌØÎÙÊ ÒÅÚÕÌØÔÁÔ). ðÏ ÉÄÅÅ ÖÅ ÒÅÚÕÌØÔÁÔ ÎÅ ÄÏÌÖÅÎ
ÚÁ×ÉÓÉÔØ ÏÔ ÐÌÁÎÁ.
ðÒÁ×ÉÌØÎÙÊ ÒÅÚÕÌØÔÁÔ ÂÕÄÅÔ ÔÁËÖÅ, ÅÓÌÉ ÕÂÒÁÔØ cast Ë double precision.
--
ó Õ×ÁÖÅÎÉÅÍ íÏÉÓÅÅÎËÏ äÍÉÔÒÉÊ
