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

[Ann Harrison]

On Fri, Sep 2, 2011 at 6:24 PM, Markus Ostenried wrote:

> On Fri, Sep 2, 2011 at 19:21, Vander Clock Stephane
>  wrote:
>
> > but i need the index :(
>
> What's the performance if you use an (ugly) hack like this:
>
> Create a column NULLFLAG (with values 0 and 1) with an index on it and
> in a trigger set it according to your NULLable column.
> Then in the SELECT statement do
> ORDERY BY NULLFLAG, FIELD
> and Firebird should use both indexes.


No, unfortunately, it won't.  When using navigational index access, Firebird
can use only one index.


Good luck,

Ann

>


[Non-text portions of this message have been removed]

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

[Markus Ostenried]

On Fri, Sep 2, 2011 at 19:21, 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.
>
> but i need the index :(

What's the performance if you use an (ugly) hack like this:

Create a column NULLFLAG (with values 0 and 1) with an index on it and
in a trigger set it according to your NULLable column.
Then in the SELECT statement do
ORDERY BY NULLFLAG, FIELD
and Firebird should use both indexes.

And maybe you can even omit the NULLFLAG column by using an index on
an expression
http://www.firebirdsql.org/refdocs/langrefupd20-create-index.html
http://www.janus-software.com/fbmanual/manual.php?book=psql&topic=56
like this:
CASE
  WHEN FIELD IS NULL THEN 0
  ELSE 1

Just a few random thoughts :)
HTH,
Markus

Re: [firebird-support] OSX GUI's

[Markus Ostenried]

On Fri, Sep 2, 2011 at 21:08, samcarleton  wrote:
> Are there any OSX GUI's for Firefox?

FlameRobin is a cross-platform GUI administration tool for Firebird:
http://www.flamerobin.org/

[firebird-support] Re: OSX GUI's

[samcarleton]

Sean, My bad, it was a mistype, I mean firebird. 

--- In firebird-support@yahoogroups.com, "Leyne, Sean"  wrote:
>
> 
> > Are there any OSX GUI's for Firefox?
> 
> Firefox???  
> 
> This is a **Firebird** SQL database group/mailing list.
> 
> 
> Sean
>

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

[Gordon Niessen]

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.
>
> but i need the index :(
>
> On 8/31/2011 12:17 AM, Mark Rotteveel wrote:
> >
> > On Tue, 30 Aug 2011 12:20:56 +0400, 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
> >
> > Something like:
> > ORDER BY field ASC NULLS LAST
> >
> > See also section Sorts in
> > http://www.firebirdsql.org/pdfmanual/Firebird-Null-Guide.pdf
> >
> >
> .
>
>
> 
What if you do a union of the not Null rows with the Null rows?

-- 
Thanks,

Gordon



[Non-text portions of this message have been removed]

RE: [firebird-support] OSX GUI's

[Leyne, Sean]

> Are there any OSX GUI's for Firefox?

Firefox???  

This is a **Firebird** SQL database group/mailing list.


Sean

[firebird-support] OSX GUI's

[samcarleton]

Are there any OSX GUI's for Firefox?

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

[Vander Clock Stephane]

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.

but i need the index :(


On 8/31/2011 12:17 AM, Mark Rotteveel wrote:
>
> On Tue, 30 Aug 2011 12:20:56 +0400, 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
>
> Something like:
> ORDER BY field ASC NULLS LAST
>
> See also section Sorts in
> http://www.firebirdsql.org/pdfmanual/Firebird-Null-Guide.pdf
>
> 


[Non-text portions of this message have been removed]

Re: [firebird-support] Why drop table can be sometime very very long ?

[Vander Clock Stephane]

thanks ann !

On 8/30/2011 11:52 PM, Ann Harrison wrote:
>
> Stephane,
>
> >
> > > > when i do drop table, sometime it's take hours to return 
> (especially on
> > > > big table)
> > > > why ?
> > >
> >
> > no, the database have only one client connected, the client that do the
> > drop table ...
> > it's not failed, it's just very very long !
> > as soon as it success, creating again and deleting again the table is
> > very fast !
> > i thing it's connected with the number or reccord in the table (in my
> > case lot of, and lot of index too)
> >
>
> Dropping a big table with lots of indexes will take longer than 
> dropping an
> empty table because of the amount of work done. Each page used by the 
> table
> must be marked free on its Page Inventory Page.
>
> To release a data page, Firebird reads the RDB$PAGES table to find pointer
> pages and marks the pages listed on the pointer pages as free until 
> the page
> is empty, then removes the pointer page entry from RDB$PAGES, then 
> marks the
> pointer page as free on its page inventory page. If enough entries are
> removed from RDB$PAGES to free up pages there, then those pages are also
> released, using the same algorithm.
>
> To release index pages, Firebird must read the whole index. It's been a
> very long time since I looked at the code that removes an index, but my
> recollection is that it goes to the lowest level of the index and releases
> pages from left to right, following the sibling pointers, then starts from
> the top again and releases the next level up.
>
> Checking the performance statistics for the number of pages read and 
> written
> will help you understand what's going on.
>
> Good luck,
>
> Ann
>
> [Non-text portions of this message have been removed]
>
> 


[Non-text portions of this message have been removed]

Re: [firebird-support] mac os x: aliases.conf

[Point Informática - Dep. de Desenvolvimento]

Thanks,

Now I can connect into firebird server, the problem is the plist file in 
/Library/Framework, but the problem now is permission!

The permission of my file is 777, but when I try to connect other 
computer using ibexpert show me:  Permission Denied.


Unsuccessful execution caused by a system error that precludes
successful execution of subsequent statements.
I/O error for file "/Users/fellipeh/Documents/Sistemas/IBEXPERT_TABLES.FDB".
Error while trying to open file.
Permission denied.


I try to put firebird user as Owner but the same problem.. how can I fix 
this?

Best Regards,
Fellipe H.

Em 02/09/11 10:35, Matthias Zitzen escreveu:
>
>  Original-Nachricht 
> Betreff: Re: [firebird-support] mac os x: aliases.conf
> Datum: Fri, 02 Sep 2011 15:27:11 +0200
> Von: Matthias Zitzen
> An: firebird-support@yahoogroups.com
>
> Hi,
>
> Am 01.09.2011 21:24, schrieb "Point Informática - Dep. de Desenvolvimento":
>> I just have problem to install in my Mac, can you send info about how
>> can I do this?
>>
> sorry, its about a year or so, but I can't remember of any troubles. I
> installed Firebird 2.0.5 as classic server on Snow Leopard...
>
> Matthias
>

-- 
___
Departamento de Desenvolvimento
Point Informática de Muriaé Ltda.
www.pointltda.com.br
Muriaé - MG
Tel/FAX: (32) 3721-5692 / 3722-5330





++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Re: [firebird-support] mac os x: aliases.conf

[Matthias Zitzen]

 Original-Nachricht 
Betreff: Re: [firebird-support] mac os x: aliases.conf
Datum: Fri, 02 Sep 2011 15:27:11 +0200
Von: Matthias Zitzen 
An: firebird-support@yahoogroups.com

Hi,

Am 01.09.2011 21:24, schrieb "Point Informática - Dep. de Desenvolvimento":
> I just have problem to install in my Mac, can you send info about how
> can I do this?
>

sorry, its about a year or so, but I can't remember of any troubles. I
installed Firebird 2.0.5 as classic server on Snow Leopard...

Matthias




++

Visit http://www.firebirdsql.org and click the Resources item
on the main (top) menu.  Try Knowledgebase and FAQ links !

Also search the knowledgebases at http://www.ibphoenix.com 

++
Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/firebird-support/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/firebird-support/join
(Yahoo! ID required)

<*> To change settings via email:
firebird-support-dig...@yahoogroups.com 
firebird-support-fullfeatu...@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
firebird-support-unsubscr...@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

[firebird-support] Error to connect in Firebird Classic Server into MacOs

[Point Informática - Dep. de Desenvolvimento]

Hello,

When I try to connect into my server, with is instaled in MacOS system, 
I receive this error:


Trying ::1...
telnet: connect to address ::1: Connection refused
Trying 127.0.0.1...
Connected to localhost.
Escape character is '^]'.
Sep  2 09:05:06 MacMini.local launchproxy[1046] : execv(): No 
such file or directory
Connection closed by foreign host.
-
Here is my: org.firebird.gds.plist

http://www.apple.com/DTDs/PropertyList-1.0.dtd";>


Disabled

Label
org.firebird.gds
ProgramArguments

/Library/Frameworks/Firebird.framework/Resources/bin/fb_inet_server

InetdCompatibility

Wait


InitGroups

Sockets

Listeners

SockServiceName
gds_db
SockType
stream
SockFamily
IPv4


OnDemand

UserName
firebird




What`s is wrong with my instalation? When I try to connect via Terminal 
using isql works fine.. doesn't work only via tcp/ip, and I don't have 
firewall enabled in my MacOS machine.

Best Regards,

-- 
___
Departamento de Desenvolvimento
Point Informática de Muriaé Ltda.
www.pointltda.com.br
Muriaé - MG
Tel/FAX: (32) 3721-5692 / 3722-5330