Oh, Dan, I'm not that clever... ;-)
But I *can* tell you that the market leading proprietary RDBMS products we
tested were not IBM, Informix, or Sybase.
Regards,
Ned
Dan Browning wrote:
Can you tell us what version of the (ahem) unnamed
proprietary products
you used? :-). For example
Hi Adrian,
We only used the released versions of each database. We'd be happy to run
the tests again when MySQL 3.23 is official, or when Interbase ships a
real ODBC driver for 6.0 for that matter.
Regards,
Ned
Adrian Phillips wrote:
It would have been more interesting if MySQL 3.23 had
Mark Kirkwood wrote:
In a related vein, is it possible that any relevant database parameter settings
might be
published to help folk get the best out of their Postgresql systems ? ( apologies if
they are
there and I missed them )
Hi Mark, here's some more info from the lead engineer on the
Doh! Sorry, I didn't cc Richard Brosnahan after all. He's at
[EMAIL PROTECTED]
Ned Lilly wrote:
Hi Jeff,
i haven't played with interbase yet, but my understanding is they have
two types of server -- the "classic" (process per connection?) and a
"superserver" (multithreaded). i'm
On Tue, Aug 15, 2000 at 12:21:25PM -0400, Ned Lilly wrote:
Oh, Dan, I'm not that clever... ;-)
But I *can* tell you that the market leading proprietary RDBMS products we
tested were not IBM, Informix, or Sybase.
And in reply to the MySQL version comment/question, Ned said:
"We only used
Actually, more RAM would permit you to increase both the -B parameters as
well as the -S one ... which are both noted for providing performance
increases ... -B more on repeative queries and -S on anything involving
ORDER BY or GROUP BY ...
For a while now, I've been meaning to
Could someone please send me some examples of the interval data type?
For example, what should the data look like in order to do and insert?
If I have two iso time stamps, how can I insert them into the interval
datatype? What are some ways to format the output of an interval type?
just wondering is postgresq a program that will allow similar things as
does microsofts's access..i use access for my current database for
company..
cuz i've noticed in the description things like "server"..which i'm
not on i'm end user of linux looking for good database for use in
Lee Johnson wrote:
just wondering is postgresq a program that will allow similar things as
does microsofts's access..i use access for my current database for
company..
cuz i've noticed in the description things like "server"..which i'm
not on i'm end user of linux looking for
Lee Johnson [EMAIL PROTECTED] writes:
cuz i've noticed in the description things like "server"..which i'm
not on i'm end user of linux looking for good database for use in linux
to switch over from using access..
postgresql is more of a competitor to Microsoft's SQL server than
I need to know how to cast types. Here's my basic problem:
I'm trying to:
update products set list_price = gsa_price * 1.1 where list_price =
gsa_price;
The error I get back is:
ERROR: Unable to identify an operator '*' for types 'numeric' and
'float8' You will have to retype this query using
Oops! You have to write a function for it. Here is a
sample quick C function:
typedef struct
{ int len;
char data[1];
} string;
string *byteatostr(bytea *arg)
{
char buf[1024];
int ln,i;
string *res;
ln = VARSIZE(arg) - VARHDRSZ;
memmove(buf,
Oops! You have to write a function for it. Here is a
sample quick C function:
typedef struct
{ int len;
char data[1];
} string;
string *byteatostr(bytea *arg)
{
char buf[1024];
int ln,i;
string *res;
ln = VARSIZE(arg) - VARHDRSZ;
memmove(buf,
"Ross J. Reedstrom" wrote:
On Tue, Aug 15, 2000 at 12:21:25PM -0400, Ned Lilly wrote:
Oh, Dan, I'm not that clever... ;-)
But I *can* tell you that the market leading proprietary RDBMS products we
tested were not IBM, Informix, or Sybase.
And in reply to the MySQL version
I'm trying to build a library for PG to add some new types. I have suceeded
to do it with no problems, but I would like to autoconf/automake the
library, so I don't have to hard code the path for resources files,
installation points, etc...
Can anyone provide me with a standard configuration:
: "Paulo Henrique Baptista de Oliveira" [EMAIL PROTECTED]
Can any one comment on this:
http://www.newsalert.com/bin/story?StoryId=CozDUWbKbytiXnZyFQ=LinuxNav=na-
search-StoryTitle=Linux
Why would anybody be surprised?
The only possible weak point in PostgreSQL is its academic heritage -- but
I've had problems after installing PostgreSQL 6.5.3 on Solaris 2.7
The sorce compiled well. but when I try to run the initdb command I get the
following error:
[6:34pm]-machine:/usr/local/pgsql/bin ./initdb --pglib=/usr/local/pgsql/lib
ld.so.1: pg_id: fatal: libncurses.so.4: open failed: No such
Ned Lilly wrote:
Oh, Dan, I'm not that clever... ;-)
But I *can* tell you that the market leading proprietary RDBMS products we
tested were not IBM, Informix, or Sybase.
That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
2 was definitely NOT MS-SQL Server?
Thanks. I figured out the CAST later but didn't know the 1.1::numeric
syntax.
-
Water overcomes the stone;
Without substance it requires no opening;
This is the benefit of taking no action.
Lao-Tse
Brian Knox
Senior Systems
Er... let me put it this way. Proprietary 2 prefers to run on Windows NT.
Chris Bitmead wrote:
That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
2 was definitely NOT MS-SQL Server?
Chris Bitmead wrote:
That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
2 was definitely NOT MS-SQL Server?
* Ned Lilly [EMAIL PROTECTED] [000815 18:59] wrote:
Er... let me put it this way. Proprietary 2 prefers to run on Windows NT.
It's oracle??? j/k
You have
Hi again. Still new to databases, and I was wondering if I could get
advice on how to set this up right. Essentially, I have a table, lets
call it main, in which each row, describes another table in the
database. I want to set it up so that, dropping the table will also
drop the
Ned Lilly wrote:
Er... let me put it this way. Proprietary 2 prefers to run on Windows NT.
The performance is so bad it must be MS-Access :-).
Chris Bitmead wrote:
That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
2 was definitely NOT MS-SQL Server?
I would like to be able to use searches that seem somewhat intelligent.
Can you 'ORDER BY' number of matching 'OR' clauses? For example, someone
searches for "x y z", so I would do "select * from mytable where col1
like '%x%' or col1 like '%y%' or col1 like '%z%';", but I want it to
order by
24 matches
Mail list logo