Re: [firebird-support] Installing Firebird 2.5 on Debian 9 Stretch

2019-01-21 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hello, Sent from my iPhone > On 21 Jan 2019, at 11:48, Gabor Boros mlngl...@bgss.hu [firebird-support] > wrote: > > 2019. 01. 21. 9:37 keltezéssel, Ertan Küçükoğlu > ertan.kucuko...@1nar.com.tr [firebird-support] írta: > > 1- Is there easier way to install firebird

[firebird-support] Installing Firebird 2.5 on Debian 9 Stretch

2019-01-21 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hello, There was an old server running Debian 7. That server crashed and had to be installed. Service provide did not have Debian 7 in install OS list and now it runs Debian 9. Seemingly, Debian removed 2.5 packages from apt-get type of install. I went down the road to compile my own firebird

Re: [firebird-support] Re: Firebird performance vs PostgreSQL

2017-09-29 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hello Dmitry, Thank you for your time. I just provided a reproducible sample. I'm not trying to make fine tuning to FirebirdSQL or PostgreSQL. Answer to your question is yes. KAYNAGAGORE and SEBEBEGORE are not indexed. Please note that they're not indexed on PostgreSQL, too. Question remains

RE: [firebird-support] Firebird performance vs PostgreSQL

2017-09-28 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
> From: mailto:firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Sent: Thursday, September 28, 2017 7:35 PM > To: mailto:firebird-support@yahoogroups.com > Subject: Re: [firebird-support] Firebird performance vs PostgreSQL > > > Hi, > > without any sample you

RE: [firebird-support] Firebird performance vs PostgreSQL

2017-09-28 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
> From: firebird-support@yahoogroups.com > [mailto:firebird-support@yahoogroups.com] > Sent: Thursday, September 28, 2017 7:35 PM > To: firebird-support@yahoogroups.com > Subject: Re: [firebird-support] Firebird performance vs PostgreSQL > > > Hi, > > without any sample you talking about

Re: [firebird-support] Rename table

2017-07-16 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Sent from my iPhone > On 16 Jul 2017, at 11:58, Alain Bastien alainbast...@gmail.com > [firebird-support] wrote: > > Else "What's in a NAME?" > > > > > > > > 2017-07-16 12:47 GMT+04:00 Alain Bastien : >> Hi, >> >> Block data

Re: [firebird-support] Rename table

2017-07-16 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Sent from my iPhone > On 16 Jul 2017, at 07:40, Alain Bastien alainbast...@gmail.com > [firebird-support] wrote: > > Create a new table with same structure from METADATA > > Use "Batchmove" (In Delphi VCL) with Delete Source enabled > > Connect the two

[firebird-support] Finding a single row

2016-05-26 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hi, I have a table where I keep some part from the beginning of a discount card number. Length of beginning is variable. User provides a complete card number at runtime, I need to find a single row in my table which begins as the complete card number, or I need to know no match exists in my

RE: !!***SPAM***!! Re: [firebird-support] Firebird V3RC2 Primary Key question

2016-04-08 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
@yahoogroups.com] Sent: Friday, April 8, 2016 10:36 AM To: firebird-support@yahoogroups.com Subject: !!***SPAM***!! Re: [firebird-support] Firebird V3RC2 Primary Key question On 7-4-2016 23:01, Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support] wrote: > Would you be so k

RE: Re: [firebird-support] Firebird V3RC2 Primary Key question

2016-04-07 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Would you be so kind to provide an example SQL which shows how to do primary key with a case insensitive collation? Thanks. Ertan From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, April 7, 2016 8:54 PM To:

[firebird-support] Firebird V3RC2 Primary Key question

2016-04-07 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hi, It's been a while since I last used Firebird. I am testing new release candidate at the moment. Just found something I am not so sure. I have a database created using "CharSet WIN1254" parameter. Below is the SQL I used to create a table in that database: CREATE TABLE KULLANICI (

[firebird-support] Firebird 3.0 RC1 (fbembed.dll)

2016-01-28 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hi All, I have subject version installed. However, I could not find and fbembed.dll file to test and play with. Is it intentionally missing? Or, there is a way to get it? Thanks. Ertan Küçükoğlu

RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

2016-01-24 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hello, I needed some time to understand (at least try to understand) your post. Please, note that my SQL knowledge is very limited. I really don’t know internals of database any system. Though, I need to develop an application which can use Firebird, Interbase, MSSQL, MySQL, Oracle. Some of

RE: RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

2016-01-21 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Oryginalna wiadomość Od: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]" <firebird-support@yahoogroups.com> Data: 21.01.2016 00:18 (GMT+01:00) Do: firebird-support@yahoogroups.com Temat: RE: [firebird-support] Firebird 3.0 RC1 - SQL o

[firebird-support] Firebird 3.0 RC1 - SQL optimization help

2016-01-20 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Hi, I have below tables. CREATE TABLE BAZLISTE ( ADRESKODU varchar(30) NOT NULL, ISLEMTURU varchar(2) NOT NULL, BELGENO varchar(30) NOT NULL, BARKOD varchar(30) NOT NULL, MIKTAR bigint, OLCUBIRIMI varchar(10), PRIMARY KEY (BELGENO,BARKOD,ADRESKODU,ISLEMTURU)

RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

2016-01-20 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
I’m all new to these things. Below is what I could find on MSSQL. I hope that is what you are looking for. From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, January 21, 2016 12:35 AM To: firebird-support@yahoogroups.com Subject: Re:

RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help

2016-01-20 Thread Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]
Sorry, for my formatting. Here is a better one. I have uploaded image. Link: http://s16.postimg.org/pz3iyujr9/Untitled.png From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] Sent: Thursday, January 21, 2016 1:13 AM To: firebird-support@yahoogroups.com Subject: