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 numbe
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?
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 associa
> 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
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?
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 Engineer
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?
>
> R
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
: "Paulo Henrique Baptista de Oliveira" <[EMAIL PROTECTED]>
> Can any one comment on this:
>
http://www.newsalert.com/bin/story?StoryId=CozDUWbKbytiXnZy&FQ=Linux&Nav=na-
search-&StoryTitle=Linux
Why would anybody be surprised?
The only possible weak point in PostgreSQL is its academic heritage
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:
Con
"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 versio
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, VARDAT
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, VARDATA
Hi,
I am having a little trouble with the runcheck regression testing of the
compilation that I just performed. I am running on a Linux Red-Hat 6.2 OS
and currently have Postgres 6.5.3 running in non-default directories and on
a non-default port. I wanted to install Postgres 7.0.2 in the def
I don't have any good ideas, but is it possible that the connections
aren't being properly terminated so the backend is staying open?
After getting the message, try doing a ps on the database machine to see
how may postgres processes are running.
Stephan Szabo
[EMAIL PROTECTED]
On 15 Aug 2000,
Well, I don't think you're going to be able to without resorting to
something other than straight sql (a c function would probably work).
You can get the value of a particular byte using get_byte(bytea,int)
but I can't think of a good way outside of some sort of function to
turn that into a split
I believe the standard way is
CAST(1.1 as numeric)
But the following should also work:
1.1::numeric
Stephan Szabo
[EMAIL PROTECTED]
On Tue, 15 Aug 2000, g wrote:
> 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
Hello.
I'm using PostgreSQL 7.0.2 with webmail IMP, but have the follow error :
Warning: Unable to connect to PostgresSQL server: Sorry, too many
clients already in ./lib/db.pgsql on line 266
But i'm with only 01 user, the error appear when the user close session and
them wish input other time
thanks anyway but that doesn't work. i should've mentioned that i'd
already tried that in SQL. my apologies.
tig4=# \d x
Table "x"
Attribute | Type | Modifier
---+---+--
tgargs| bytea |
tig4=# select substr(tgargs,1,5) from x;
ERROR: Function 'substr(by
Hi,
I'm wondering if it is possible to access the properties of an attribute?
i.e. if a given field is a foreign key or primary key, or if it is integer
or varchar, etc.
Is it possible to do this? I know postgres stores all of its informations in
other tables, i.e. pg_tables etc, so is this info
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
Try
substr(text,int4) or
substr(text, int4, int4)
For example,
% select substr('hi there',4,3);
substr
the
(1 row)
Morey Parang
ORNL
On Tue, Aug 15, 2000 at 03:34:27PM -0400, mikeo wrote:
> hi all,
>in the pg_trigger table the tgargs column is defined
> as type "BYTEA". i ca
hi all,
in the pg_trigger table the tgargs column is defined
as type "BYTEA". i can split this up in perl, once
retrieved, but can't figure out how to "substring"
it in sql. is there an SQL way to select pieces of
a column of this type?
any help is appreciated,
mikeo
Can any one comment on this:
http://www.newsalert.com/bin/story?StoryId=CozDUWbKbytiXnZy&FQ=Linux&Nav=na-search-&StoryTitle=Linux
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
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 f
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
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?
> 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 investi
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 u
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).
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
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 bee
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 exam
34 matches
Mail list logo
