Enrico Comini writes:
Hi, how I have to change the next query ?
da_kg=Numeric
a_kg =Numeric
cusiodb=# SELECT * FROM tavola_pesi WHERE ((da_kg 3.5) and (a_kg = 3.5));
ERROR: Unable to identify an operator '' for types 'numeric' and 'float8'
You will have to retype this query
On 28 Sep 2000, Gunnar R|nning wrote:
Tim Kientzle [EMAIL PROTECTED] writes:
I'm finding that ... my CPU spends about 60% of the time in JDBC, and about
40% of the time in the postmaster backend.
(Each query takes 2 msec on my machine, RH Linux 6.2, 733 MHz Intel, w/
lots of
I know all of you are accustomed to the command
line interface for pgsql. (Of course, some of you created it!)
However, I'd be interested if anyone else feels the way I do
I would prefer to have a consistent set of names
for the commands. For example,
I propose the following:
Instead
Well, I'm not even a new user, I'm maybe a future new user but interested
right now. With the exception of the help command, I don't see any need to
change commands names. But the help command would be very helpful.
- Original Message -
From: Keith L. Musser
To: PGSQL-General
Sent:
I'd assume a problem with changing all the commands now is that it may break
a lot of people's scripts and programs.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
- Original Message -
From: "Keith L. Musser" [EMAIL PROTECTED]
To: "PGSQL-General" [EMAIL PROTECTED]
Sent:
"Adam Lang" [EMAIL PROTECTED] writes:
I'd assume a problem with changing all the commands now is that it may break
a lot of people's scripts and programs.
Well, we've done it before ;-). If memory serves, the create/drop
scripts *were* named pg_xxx a few years back. I forget the reasons
that
Hi,
I'm pretty new to PgSQL (been lurking) and am wondering if
it's possible to talk with other DB's easily? I'm using
FreeBSD atm and the project I'm working on will be moving
from dbase to postgres in the next release. It will also
have a web based side to it that I plan on using MySQL for
Hello,
In a SPI function I have this code snippet:
double startprice = *DatumGetFloat64(SPI_getbinval(
auction_tt-vals[i], auction_tt-tupdesc,
SPI_fnumber(auction_tt-tupdesc,
"startprice"), isnull));
To
Hi,
I'm pretty new to PgSQL (been lurking) and am wondering if
it's possible to talk with other DB's easily? I'm using
FreeBSD atm and the project I'm working on will be moving
from dbase to postgres in the next release. It will also
have a web based side to it that I plan on using MySQL
Louis-David Mitterrand [EMAIL PROTECTED] writes:
In the provided example SPI functions I couldn't determine a good way of
testing for NULL on columns. Should I first try to return the Datum,
test it for NULL, then run DatumGetFloat64() on it? Isn't there a
simpler way?
Yes. No. The Datum
oops...meant to send to list.
| Daryl Chance | I have made this letter longer then |
| Valuedata, LLC | usual because I lacked the time to |
| Memphis, TN| make it shorter. -- Blaise Pascal |
Howdy!
I continually get the following error when I truncate a very large table in
my db:
NOTICE: trying to delete a reldesc that does not exist
Is this something that I should be concerned about?
Thanks for the help!
Darrin
If memory serves me correctly, Virtuoso (OpenLinkSW) and AOLserver both claim
inter-database connections.
= Original Message From "Mitch Vincent" [EMAIL PROTECTED] =
Hi,
I'm pretty new to PgSQL (been lurking) and am wondering if
it's possible to talk with other DB's easily? I'm
Daryl Chance wrote:
I know MySQL is fast but just remember, it's just "A filesystem with an
SQL
interface" -- that's ALL... :-)
Cool, thats what I needed to know. as for MySQL, thats about all I really
need :P.
without knowing the hardware organization availability of software,
without knowing the hardware organization availability of software,
it's seems strange that you're considering different database systems
for things that one is perfectly capable of performing. it's a bit of a
fallacy that MySQL is better for read only database sites. on the low
end
On Thu, Sep 28, 2000 at 11:00:20AM -0500, Daryl Chance wrote:
without knowing the hardware organization availability of software,
it's seems strange that you're considering different database systems
for things that one is perfectly capable of performing. it's a bit of a
fallacy that
I have several databases in one implementation. Do I have to
dump/restore them all to get the pg_log file under control?
Thanks
John
"Mikheev, Vadim" wrote:
My "pg-log" file is getting huge. I tried to zero it out with
disastrous consequences. I can find no documentation on what it
is
It would probably be easy to create a link, or a script called pg_XXX that
executes the command XXX. I'd rather have createdb instead of pg_createdb
just because it's easier to type. A script that creates the pg_ command
names could be written and made available at someone's web site for
I was about to say that it may cause more harm than good, but...
If they do want to move the utilities to the /bin folder, then that may be a
good solution. pg_access, pg_createdb etc would be put there and merely
mapped to the usual location of the createdb utilities.
That would solve the
Does anyone know how to invoke an external shell script from a function when
it is called from a sql statement?
-- Artemis Chau, Intel Corp.
The performance of my client Java app using JDBC to access PGSL is very
finicky. Sometimes it's fast, and sometimes it's slow, depending on how
much memory I'm allocating in my program.
This appears to be an issue with the JVM I'm using on Linux.
Performance is very consistent using HotSpot
21 matches
Mail list logo