Hello Dmitry!
On 2014.05.02. 8:34, Dmitry Yemanov wrote:
> 30.04.2014 13:50, Molnár Attila wrote:
>> *SIZE OF , SCALE OF > domain or variable name>*
>> - SIZE OF : returns max CHAR/VARCHAR length or NUMERIC precision,
>> SCALE OF : return scale of NUMERIC
>> - gain : by defining a vari
05.05.2014 11:05, Molnár Attila wrote:
>
> I'm createing domains, and using TYPE OF. But as I write it's not
> enough. This is just for variable declaration but I need a pair in PSQL
> body. Maybe this example would help to understand.
>
> EXECUTE BLOCK
> AS
> DECLARE VARIABLE tmp TYPE OF COLUMN rd
On 2014.05.05. 9:27, Dmitry Yemanov wrote:
> 05.05.2014 11:05, Molnár Attila wrote:
>> I'm createing domains, and using TYPE OF. But as I write it's not
>> enough. This is just for variable declaration but I need a pair in PSQL
>> body. Maybe this example would help to understand.
>>
>> EXECUTE BL
On 05/04/14 13:39, Claudio Valderrama C. wrote:
>> -Original Message-
>> From: Simonov Denis [mailto:sim-m...@list.ru]
>> Sent: Domingo, 04 de Mayo de 2014 5:11
>>
>>
>> Not handled correctly is such a design in Legacy API.
>>
>> IBExpert
>>
>> execute block
>> as
>> begin
>> suspend;
Can not run ALTER TABLE DROP CONSTRAINT after recent changes in svn
-
Key: CORE-4418
URL: http://tracker.firebirdsql.org/browse/CORE-4418
Project: Firebird Core
Iss
Am 05.05.2014 08:48, schrieb Molnár Attila:
>> I believe that there are UDFs available for this already, no?
> A very old and unsuppoted udf. In my case I do not expect to read back
> from file to DB just one way.
It's old but not unsupported :-)
And works as expected.
ftp://freeadhocudf.org/adh
On 5/2/2014 3:25 PM, Vlad Khorsun wrote:
>> OK, the alternative to record lookups is to store the transaction id in
>> index. This would require an index insertion for all indexes defined on
>> a table even if the key value didn't change. It would also require a
>> corresponding index deletion fo
05.05.2014 19:06, Jim Starkey wrote:
> My sole reservation is that there can be information lost when a large
> valued 64 integer is converted into a double to generate the index key.
AFAIR, int64 integers are not converted into double, they're compressed
using their native format.
> My second
On 5/5/2014 11:53 AM, Dmitry Yemanov wrote:
05.05.2014 19:06, Jim Starkey wrote:
My sole reservation is that there can be information lost when a large
valued 64 integer is converted into a double to generate the index key.
AFAIR, int64 integers are not converted into double, they're compresse
05.05.2014 17:06, Jim Starkey wrote:
> My third concern is that garbage collection will be very tricky, but as
> lone as the going/staying lists are maintained, doable.
Actually, transaction numbers in nodes should allow to stop using
going/staying lists
among with overhead of collecting them
combination of stored function, union, joins and order by crashes server
Key: CORE-4419
URL: http://tracker.firebirdsql.org/browse/CORE-4419
Project: Firebird Core
Issu
CAST behaving differently in version 2.5
Key: CORE-4420
URL: http://tracker.firebirdsql.org/browse/CORE-4420
Project: Firebird Core
Issue Type: Bug
Components: Engine
Affects Versions: 2
12 matches
Mail list logo
