[GENERAL] How to become a Windows beta-tester?

2004-01-16 Thread Paul Ganainm
Hi all, I would be interested in playing around with the beta version for the Windows native port - where can I get it? TIA. Paul... -- plinehan y_a_h_o_o and d_o_t com C++ Builder 5 SP1, Interbase 6.0.1.6 IBX 5.04 W2K Pro Please do not top-post. "XML avoids the fundamental question

Re: [GENERAL] serverless postgresql

2004-01-15 Thread Paul Ganainm
[EMAIL PROTECTED] says... > > That makes sense to me. I wonder if sqlite suffers for this problem > > (e.g. app crashing and corrupting the database). > Likely. I can tell you that Ann Harrison once told me she made a decent > amount of money as a consultant fixing broken Interbase/Firebi

Re: [GENERAL] Is my MySQL Gaining ?

2004-01-05 Thread Paul Ganainm
[EMAIL PROTECTED] says... > err... i think you misunderstood... I'm was looking for a link to show the > mozilla folks saying they would stop using the firebird name. I've never > heard such a thing, while I have heard the opposite, and the info you site > above only seems to verify that mozi

[GENERAL] Groff and Weinberg SQL Complete Reference - Sample database?

2003-12-22 Thread Paul Ganainm
Not really a PostgreSQL question, but maybe somebody here knows the answer! I recently purchased Groff and Weinberg's The Complete Reference SQL, and a fine meaty tome it is too! However, I find to my absolute *_horror_* that there doesn't appear to be an electronic version of the sample d

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-21 Thread Paul Ganainm
[EMAIL PROTECTED] says... > > What then is a derived table, or is a derived table just a synonym for > > inline view? > I'm not sure what the "official" name for this is. I have heard both. So > from my point of view a derived table and an inline view are the same. OK - I'm fine with the

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-21 Thread Paul Ganainm
[EMAIL PROTECTED] says... > >>SELECT count(*) FROM (SELECT col1, col2 FROM table) > > I did select count(*) from phone_list and it worked. > Sure you can do a select from a view, but try the above statement where the > view definition is "embedded" diretly into the SELECT. This is not > su

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-21 Thread Paul Ganainm
[EMAIL PROTECTED] says... > Paul Ganainm schrieb: > FB does not support inline views/derived tables, e.g.: > SELECT count(*) FROM (SELECT col1, col2 FROM table) If you have IB/FB, there is a sample db that comes with it, Employee. There is a view in that db called phone_lis

Re: [GENERAL] BLOBS : how to remove them totally

2003-12-20 Thread Paul Ganainm
[EMAIL PROTECTED] says... > That's a good discussion, but it left out at least one useful bit of > info about managing large objects: there's a contrib utility > (contrib/vacuumlo) that can find and remove large objects that are not > referenced anywhere in the database. What is the URL for

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-17 Thread Paul Ganainm
[EMAIL PROTECTED] says... > A partial index is a index on a subset of a table. The case I can think of > is a list of transactions, some of which are yet to be billed. They have a > BillID field which is NULL. since this is the recent set it is queried quite > often, so you can build an index li

Re: [GENERAL] Firebird and PostgreSQL at the DB Corral.

2003-12-17 Thread Paul Ganainm
[EMAIL PROTECTED] says... > > Ditto for FB. If you want to extend the code, though, you have to give > > those changes back to the community - the licence is more GPL than BSD. > maybe you need to clarify what you think of when you say "extensible". > postgresql has sql extensions like "cre

Re: [GENERAL] add column sillyness

2003-12-16 Thread Paul Ganainm
[EMAIL PROTECTED] says... > AFAICT, the main thing that Firebird lacks is a viable open-source > development community :-(. This is untrue - go to www.ibphoenix.com and follow the links to the lists. > It's a nice bit of software, and I'd be > happy to see it doing better, but it seems lik

Re: [GENERAL] add column sillyness

2003-12-16 Thread Paul Ganainm
[EMAIL PROTECTED] says... > Last night after posting this I asked myself. Could I get the same kind of > support (basically an answer to any question within 24 hours from one of the > actual postgres developers) with firebird that I can get here? I doubt it. www.ibphoenix.com - go to lists a

Re: [GENERAL] add column sillyness

2003-12-16 Thread Paul Ganainm
[EMAIL PROTECTED] says... > Yes, I didn't mean to make a statement about firebird support (which I know > nothing about) But that didn't stop you actually making an (untrue) statement about it! > but rather I was just trying to comment on and show > appreciation for the amazing support that

Re: [GENERAL] add column sillyness

2003-12-16 Thread Paul Ganainm
[EMAIL PROTECTED] says... > tested, solid, native replication both syncronous and asyncronous (at least > they list this as a feature, I assume it works as advertised) As an Interbase/Firebird user, I'm confused by this. There is a replication solution, but AFAIK, it's commercial - not Open

[GENERAL] Database of electoral results?

2003-11-07 Thread Paul Ganainm
Hi all, This is not so much a question specific to PostgreSQL, but rather a general "application of theory" type of problem! I did post this on comp.databases.theory but received no replies there. If anyone here is interested and this is a suitable forum in the PostgreSQL hierarchy, that w