Sent: Thursday, December 26, 2019 4:57 PM
To: firebird-support@yahoogroups.com
Subject: Re: [firebird-support] Identify computed by columns in table
26.12.2019 13:11, ertan.kucuko...@1nar.com.tr [firebird-support] wrote:
> left join
Left join here can unnecessary kill performance. There ca
ubject: Re: [firebird-support] Identify computed by columns in table
26.12.2019 11:53, ertan.kucuko...@1nar.com.tr [firebird-support] wrote:
> I need to identify columns in a table created as "computed by"
These columns have DRB$FIELDS.RDB$COMPUTED_BLR not
Hello,
I am using Firebird 2.5.9 on Windows OS.
I need to identify columns in a table created as "computed by"
If I check rdb$relations I only see them as float fields. However, database
tools are able to see their column type as "computed by ..."
Any help is appreciated.
Thanks & regards,
Ert
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
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 2.5
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 a
> 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 talking
> 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 nothin
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 entrance ?
Hello,
We do not know how busy table is. There
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 tables, MOVE DATA
>
> Drop the empty t
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 table.
@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 kind
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@yahoogroups
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
(
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
Is there any utf-8 code page that can be used as database charset? So, there
will be possibly no more such issues.
Sent from my iPhone
> On 27 Jan 2016, at 15:25, Dimitry Sibiryakov s...@ibphoenix.com
> [firebird-support] wrote:
>
> 27.01.2016 14:15, blumy2...@yahoo.com [firebird-support] wro
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 use
you have not
> defined indexes on filtered columns
>
> regards,
> Karol Bieniaszewski
>
> Oryginalna wiadomość
> Od: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]"
>
> Data: 21.01.2016 00:18 (GMT+01:00)
> Do: firebird-su
ewski
Oryginalna wiadomość
Od: "Ertan Küçükoğlu ertan.kucuko...@1nar.com.tr [firebird-support]"
Data: 21.01.2016 00:18 (GMT+01:00)
Do: firebird-support@yahoogroups.com
Temat: RE: [firebird-support] Firebird 3.0 RC1 - SQL optimization help
Sorry, for my format
Yes, this is information I need. Is it better to have a full index?
Sent from my iPhone
> On 21 Jan 2016, at 00:17, liviusliv...@poczta.onet.pl [firebird-support]
> wrote:
>
> Hi,
>
> i see that you have only partial key usage on 1/4
> only BelgeNo is used because you do not use “BARKOD” – i
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: RE
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: [
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)
)
23 matches
Mail list logo