I have plperl compiled, installed, and generally working on
Solaris. But when I try to execute the sqrt function, an error
is issued:
ERROR: creation of function failed: sqrt trapped by operation
mask at (eval 10) line 4.
The number after eval changes depending on where I put the line
of code
Maybe try something like:
SELECT to_char(mytable.date + mytable.time, 'HH:MIAM');
That puts your separate date and time fields together into a timestamp, then
you can use to_char.
If you don't have a mytable.date, I think you could just do:
SELECT to_char(CURRENT_DATE + mytable.time, 'HH:MIAM
hi,
[EMAIL PROTECTED] (Guillaume Lémery) wrote in <3A65C7E4.3020202
@comclick.com>:
[...]
>And an Index :
>
>CREATE INDEX ae_tracking_idx ON accord_editeur(id_regie, num_editeur,
>num_site, num_emplacement);
In this Index creation you specified that *one* index will index *four*
rows, and to d
Hello all,
How would I setup a sequence that would reflect, for example, abc-0001?
On Wed, 17 Jan 2001, Richard Seymour wrote:
> The site says 7.0.3 is the current version. The docs on the site are for
> version 7.1. There are a few bugfixes / features in 7.1 that may be
> useful.
If you look in the developer's area you will find the docs for the
development version. If you l
Richard Seymour writes:
> The site says 7.0.3 is the current version. The docs on the site are for
> version 7.1.
You must be looking at the wrong link then.
There are a few bugfixes / features in 7.1 that may be
> useful.
>
> When's version 7.1 probably going to be considered current? When sh
I wasn't following the thread too closely, but database for a filesystem has
been done. BeOS uses a database for a filesystem as well as AS/400 and
Mainframes.
Adam Lang
Systems Engineer
Rutgers Casualty Insurance Company
http://www.rutgersinsurance.com
- Original Message -
From: "Alfred
On Wed, Jan 17, 2001 at 01:03:05PM +0100, Mirko Zeibig wrote:
> On Tue, Jan 16, 2001 at 12:22:28PM -0800, Adam Haberlach wrote:
> > On Tue, Jan 16, 2001 at 12:58:41PM +0100, Mirko Zeibig wrote:
> > > On Mon, Jan 15, 2001 at 07:54:26PM -0800, Adam Haberlach wrote:
> > > > I've got the following pro
Hi:
I've been trying in vain for over 5 hours now to compile
PostgreSQL 7.0.3 on Solaris 7 (2.7).
I keep getting the following error:
ld -G -o libpq++.so.3.1 pgconnection.o pgdatabase.o pgtransdb.o
pgcursordb.o pglobject.o -L../../interfaces/libpq -lpq -ldl -lsocket
-lresolv -lnsl -lm -lc
pg
* Robert D. Nelson <[EMAIL PROTECTED]> [010117 05:17] wrote:
> >Raw disk access allows:
>
> If I'm correct, mysql is providing a filesystem, not a way to access raw
> disk, like Oracle does. Huge difference there - with a filesystem, you have
> overhead of FS *and* SQL at the same time.
Oh, so
Well I finaly got around to trying the to_char function. And I am having
difficulty getting it to do what I want elegantly.
Here is the situation...
I am tracking the time that an event occurs in a column of type time.
(seperate column for date). I want to display the time of the event in a
f
"Gordan Bobic" <[EMAIL PROTECTED]> writes:
> CREATE VIEW LastDate AS
> SELECTCompany,
> max(Date) AS Date
> FROMPastInvoices
> GROUP BYCompany;
> And then call it like
> SELECT Date FROM LastDate ORDER BY Date WHERE Company = 'SomeCompany';
> It ta
snef wrote:
> Hi,
> I have read the man's with Postgres.
> But I can't seem to get Postgres use European time notation (dd/mm/).
>
> Where can I adjust this? (in which file?)
>
> Snef
Actually, I think you may want the environment variable PGDATESTYLE. It
sets the datestyle for new connecti
What is this?
ERROR: index_formtuple: data takes 16468 bytes: too big
When a try VACUUM ;
Somebody can help?
[]'s
Eriko
Hi,
I have read the man's with Postgres.
But I can't seem to get Postgres use European time notation (dd/mm/).
Where can I adjust this? (in which file?)
Snef
On Sun, Jan 14, 2001 at 12:58:16PM -0500, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> >> The effect in terms of query execution speed is probably minimal. The
> >> problem is that the executables get about 15% larger, which can lead to
> >> longer load times, more memory usage,
The site says 7.0.3 is the current version. The docs on the site are for
version 7.1. There are a few bugfixes / features in 7.1 that may be
useful.
When's version 7.1 probably going to be considered current? When should
I consider it safe for use in a production site?
--
Richard Seymour : Anar
Greetings.
My problem is to find percent character in some field.
I'm wonder how specify percent character or other wildcard characters
in 'LIKE patterns'?
Many thanks in advance,
Sergey.
Hello, people.
I'm triing to find some information, which relates POSTGRES and
PostgreSQL, for a class.
I was looking in the documentation, and in the book beeing written
("PostgreSQL: Introduction and Concepts", by Bruce Momjian) but I could
not find anything but instructions of the SQL sinta
Hi !
I have a big problem using Indexes which slows my database.
I have a table with lot of data (> 500 000):
CREATE TABLE accord_editeur
(
id_regie int8 not null,
num_campagne int8 not null,
num_publicite int8 not null,
num_editeur int8 not null,
num_site int8 not null,
num_emplacement int8 no
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> Can anyone suggest what may be happening here?
> The original bug report was that initdb stuck with postgres consuming
> most of the CPU cycles.
Now that I see the original bug report, I see that you omitted a rather
critical piece of information, n
Philip Hallstrom wrote:
>
> You're right of course, I should have left that out... but my point is
> still valid.
Pointing out the serious limitations in MySQL is not, IMHO, bashing.
MySQL currently has serious limitations for many RDBMS uses.
Concurrent performance under industry-standard ben
Hi.
I have just upgraded from v7.0.3 to v7.1b3, and one of the things I am
noticing is that doing a max() query search seems to take forever.
For example, if I have a view like:
CREATE VIEW LastDate AS
SELECTCompany,
max(Date) AS Date
FROMPastInvoices
I believe "Number" should work, refer to the postgres Manual:
http://www.postgresql.org/docs/user/x524.htm
- Stuart
> -Original Message-
> From: Fausto Guzzetti [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, January 17, 2001 1:21 PM
> To: PostgreSQL General
> Subject: Re: MySQL file sy
hafiz wrote:
> I use Postgresql 7.0.3-2 in red-hat 6.2
> I change several postmaster options through postgresql.conf (in
> /usr/local/pgsql/data) . But it seems
> that the postmaster still run using default values and ignored
> postgresql.conf. I've check the file permission and it should be ok.
hafiz writes:
> I use Postgresql 7.0.3-2 in red-hat 6.2
>
> I change several postmaster options through postgresql.conf (in
> /usr/local/pgsql/data) . But it seems
> that the postmaster still run using default values and ignored
> postgresql.conf. I've check the file permission and it should be o
Joseph Shraibman <[EMAIL PROTECTED]> writes:
> Anyway I look at http://www.selectacast.net/~jks/postgres/gdb3.txt The
> backend was in ExecEvalVar () when it crashed.
It sort of looks like the plan generated for a mergejoin must have been
bogus, but with only routine names to go on, it's hard to
> >Then I realized that although I had the disk space for the total file
> >size, they were mostly smaller than a block on my disk, so I was going
> >to loose alot of space.
>
> The solution to this is sub-allocation, which Novell has achieved. NOT a
DB
> filesystem.
>
> >It's not earth shatterin
"Oliver Elphick" <[EMAIL PROTECTED]> writes:
> Can anyone suggest what may be happening here?
> The original bug report was that initdb stuck with postgres consuming
> most of the CPU cycles.
> Now initdb has succeeded but `\d prova' in a test database consistently
> stalls, again with postgres t
Hello,
I have what I think is a trivial problem. But I wasn't able to find a solution
in the FAQ or in the docs I have.
It has to do with case sensitivity. I am working with an application of
PostrreSQL (7.02) and PHP4.
My table name is (for example) avi_f_amm and contains a field named Number
30 matches
Mail list logo
