[firebird-support] SEGMENT SIZE

I am working with FB 2.5. I have read that SEGMENT SIZE really does not matter for BLOBs. Yet, in writing UDFs you deal with MaxSegmentLength and SegmentCount. So the default SEGMENT SIZE of 80 seems low for storing even fairly small binary files. Are there any recommendations on setting th

Re: [firebird-support] how to put null at the end in oder by ASC

On 8/30/2011 2:03 PM, Markus Ostenried wrote: > > On Tue, Aug 30, 2011 at 10:20, Vander Clock Stephane > mailto:svanderclock%40yahoo.fr>> wrote: > > Hello, > > > > how to put the num value at the end of the result (and not at the > > beginning) when we are doing > > > > select xxx order by xxx ASC

Re: [firebird-support] how to put null at the end in oder by ASC

On 9/2/2011 12:21 PM, Vander Clock Stephane wrote: > > unfortunatly > > If you override the default NULLs placement, no index will be used for > sorting. In Firebird 1.5, > that is the case with NULLS FIRST. In 2.0 and higher, with NULLS LAST on > ascending and > NULLS FIRST on descending sorts.

Re: [firebird-support] Re: delete from table... best way?

On 9/15/2011 4:17 PM, Sergio wrote: > ... foreign key (id_driver) references drivers(id)... What Daniel was indicating is that if the foreign key was set to cascade, then when you deleted the associated driver, then the cars would also be deleted. You may have is currently set to change the ID

[firebird-support] Delete Performance Issue

I am using FB 1.5 and doing a delete from a large table using the primary key as a reference from a sub select delete from tableA where ID in (select ID from tableB where someval = 'x') The subquery is fast and looks like it uses the index. But the plan for the delete is (ID NATURAL) and take a

Re: [firebird-support] Re: How to insert only if a matching row does not exist?

Not sure why this did not post the first time. See below: On 10/20/2011 11:28 AM, gastrocus wrote: > > > > --- In firebird-support@yahoogroups.com > , Helen Borrie > wrote: > > > > >What is the analogous way to achieve this in Firebird (2.5) ? > > > >

Re: [firebird-support] how to combine a field value while their id is same?

On 10/23/2011 10:01 AM, Mark Rotteveel wrote: > > On 23-10-2011 16:05, ibmcom2011 wrote: > > > > now i have a table such as: > > > > f1 f2 > > 1 aa > > 2 tf > > 1 bb > > 3 cc > > 2 ht > > > > i want the result seems as: > > > > f1 f2 > > 1 aa, bb > > 2 tf, ht > > 3 cc > > > > any help is appreciate

Re: [firebird-support] Error CREATE VIEW (code = -607)

On 10/26/2011 9:34 AM, eric_developer wrote: > > Hi, > > how to solve? simple example: > > RECREATE VIEW TMP_REGC100 AS > SELECT CODFOR > FROM TMP_NFENT > GROUP BY 1 > UNION all > SELECT CODEMP > FROM TMP_NFSAI > > --- > Dynamic SQL Error > SQL error code = -607 > Invalid command >

Re: [firebird-support] Re: How to insert only if a matching row does not exist?

On 10/20/2011 11:28 AM, gastrocus wrote: > > > > --- In firebird-support@yahoogroups.com > , Helen Borrie > wrote: > > > > >What is the analogous way to achieve this in Firebird (2.5) ? > > > > INSERT INTO emp (fruits) values ('mango') > > where not exi