Hello,
I have to design a table wich will store some action reports. Each
report have an ID like this 1/2004, 2/2004, ... and each years, they
restart to 1 (1/2004, 1/2005, 1/2006,...).
So, I was thinking to split that in two fields : one with the increment
and one with the year. But I don't
Hello,
I created a table where a record consists of a single field of type
lo. I'm trying to add a new record and store the contents of a file in
it. However, when I call CRecordset.Update() I get the following
exception: SetPos with data_at_exec not yet supported. My table
doesn't get updated.
On Tue, Apr 20, 2004 at 12:48:42PM -0700, Han Holl wrote:
Can anyone explain to me what I'm doing wrong:
(The first select is to show that the function rubriek exists, and does work).
I want to create an index on a computed column:
Functional indexes could not have constants in 7.3; you can
On Thu, Apr 22, 2004 at 09:42:12AM -0400, Eric Comeau wrote:
What is Oracle selling as their replication solution these days?
[. . .]
Their ORAC if I understand it correctly is a cluster solution and
no a replication solution.
This is an example of why I think most of the discussion
Philipp Buehler wrote:
On 22/04/2004, Guy Fraser [EMAIL PROTECTED] wrote To [EMAIL PROTECTED]:
Shouldn't the Database server be the entity that decides when vacuum is
needed?
How is the database supposed to know when you want to purge records?
Once a vacuum has been run, the table can
Bruno, perhaps round is an issue. Thank you. Here is an example that
should involve no rounding and indeed it works:
Multiply the ten largest integer scale prime numbers:
# select 2147483477::numeric * 2147483489::numeric * 2147483497::numeric
* 2147483543::numeric * 2147483549::numeric *
Chris wrote:
[SuSE]
I would appreciate if someone can give me hand
so I can have a good experience installing postgresql .
If you're a complete *nix newbie you should consider
using the precompiled PostgreSQL package that comes with
your copy of SuSE. You can install it with Yast.
Yes - I
David Garamond wrote:
Bruce Momjian wrote:
David Garamond wrote:
Is there a feature similar to this currently in Postgres, or will there
be? Sometimes (like in a shared hosting environment), we cannot have the
luxury of hot-swapped RAID or expensive SAN, and it's nice to be able to
On Mon, Apr 26, 2004 at 13:30:17 -0400,
Chadwick Boggs [EMAIL PROTECTED] wrote:
Example of wrong results from modulo operation of arbitrary precision
numbers:
# select '123456789012345678901234567890'::numeric % 123;
?column?
--
-6
(1 row)
# select
On Tue, Apr 20, 2004 at 02:32:07PM -0700, Gralewski Daniel wrote:
Does tsearch2 support indexing on bytea column?
I'll have a table where i'll put any kind of file:
xml, txt, pdf, gif, jpg. And i would like textual
search on it.
As long as you can come up with text for the files ... what
On Tue, 20 Apr 2004, Han Holl wrote:
Hi,
Can anyone explain to me what I'm doing wrong:
(The first select is to show that the function rubriek exists, and does work).
I want to create an index on a computed column:
palga= select rubriek(rapport, lseek, 'naamvrouw',0) from main
where
On Mon, Apr 26, 2004 at 10:18:52 -0400,
Chadwick Boggs [EMAIL PROTECTED] wrote:
I need to perform modulo operations on extremely large numbers. The %
operator is giving me number out of range errors and the mod(x, y)
function simply seems to return the wrong results. Also, my numerator
Hi,
from 7.3 I created a backup by:
pg_dumpall backup
from 7.4 trying: pg_restore backup
results in postgres' [Archiver]s suspicion that backup
was not a valid archive.
Where to look?
TIA Erwin
---(end of broadcast)---
TIP 4: Don't 'kill
On Mon, Apr 26, 2004 at 08:11:37AM -0400, Ken Harris wrote:
About 3 weeks ago, I started receiving double messages from all the postgresql
lists. This generated quite a bit of extra email and was very annoying. I
decided to prune down the number of lists that I subscribed to, so I started
On Tue, 20 Apr 2004, Han Holl wrote:
palga= create index nm_idx on main (rubriek(rapport, lseek, 'naamvrouw',0));
ERROR: parser: parse error at or near 'naamvrouw' at character 54
palga=
This is postgresql-7.3.4-3.rhl9.
You cannot create functional indexes with a constant in the 7.3
On Fri, 23 Apr 2004, Sumita Biswas wrote:
Hi All,
Our application is using the Postgres 7.3.4-RH database that is packaged
with the AS3.0 for CCM. There is a variable type called refcursor that
is being used by CAR Functions in Postgres database. This variable works
fine when we execute
Example of wrong results from modulo operation of arbitrary precision
numbers:
# select '123456789012345678901234567890'::numeric % 123;
?column?
--
-6
(1 row)
# select mod('123456789012345678901234567890'::numeric, 123);
mod
-
-6
(1 row)
The correct result (at least according
Bruce Momjian wrote:
David Garamond wrote:
Is there a feature similar to this currently in Postgres, or will there
be? Sometimes (like in a shared hosting environment), we cannot have the
luxury of hot-swapped RAID or expensive SAN, and it's nice to be able to
have a synchronous backup so that
Bill Moran wrote:
Stephen Salbod wrote:
My background is Windows and I just switched, yesterday to, Suse Linux
Professional 9.0. And I have a class project due Monday, which is on
why select postgresql as your DBMS. I am trying to install postgresql
Let this be a lesson - never change
On Mon, Apr 26, 2004 at 03:53:39AM +, tech tech wrote:
I want to install postgresql in /usr/local/pgsql except libraries are in
/usr/local/pgsql/lib/LIB_new.
Is it ok the following configure options?
$ ./configure --prefix=/usr/local/pgsql
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Do a vacuum full, not just a vacuum.
On Saturday 24 April 2004 10:13 pm, Simon Moses wrote:
dear sir,
i used to load 70 Mb flatfile data into postgresql database in less than 1
hour with my java code. two days back i gave VACUUME command and
On Mon, Apr 26, 2004 at 08:11:37 -0400,
Ken Harris [EMAIL PROTECTED] wrote:
About 3 weeks ago, I started receiving double messages from all the postgresql
lists. This generated quite a bit of extra email and was very annoying. I
decided to prune down the number of lists that I subscribed
On Mon, Apr 26, 2004 at 10:18:52 -0400,
Chadwick Boggs [EMAIL PROTECTED] wrote:
I need to perform modulo operations on extremely large numbers. The %
operator is giving me number out of range errors and the mod(x, y)
function simply seems to return the wrong results. Also, my numerator
After takin a swig o' Arrakan spice grog, [EMAIL PROTECTED] (kostas) belched out:
I am new to Object Relational DBMS like Postgresql. I want to ask, What is
the key benefits of ORDBMS over RDBMS. Do you know any link with relevant
informations. Thank you in advance.
Well, the key thing is that
Environment: Server running Redhat 3.2.3-20 on quad Xeon 2.4
Postgresql 7.4 compiled from source (gcc 3.2.3)
Application written in Perl (5.8.0) using Tk,
DBI and DBD
Client accessing DB using ODBC (7.03.02) from
Win XP box
[EMAIL PROTECTED] said:
How not sure are you?
Not not sure at all.
But I'd welcome a correction to my
thinking from anyone that really-truely-for-sure (like in source code
level intimacy) knows.
Me too!
Because while I was blissfully sure in my ignorance before, now I'm really
not sure! :)
Did you try
ORDER BY
date_part('year', uu.add_date) desc, date_part('month', uu.add_date) desc,
date_part('day', uu.add_date) DESC;
Regards,
Clodoaldo
--- OtisUsenet [EMAIL PROTECTED] escreveu: Hello,
I am trying to select distinct dates and order them in the reverse
chronological
Can you send me detailed information for distribution license of Postgre SQL
Database server.
I would like to use Postgre SQL Database for distribution with my comercial
product to customers. So do I require to buy any distribution license or it
can be distributed without any license as a
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
ORDER BY
date_part('year', uu.add_date), date_part('month', uu.add_date),
date_part('day', uu.add_date) DESC;
You are sorting by three columns, only the last one is desc.
What you need is:
...
order by
date_part( 'year', uu.add_date )
Hello Jean,
El 25/04/2004 8:57 PM, Jean-Claude Adams en su mensaje escribio:
Hi Folks.
I need some tutorial or some expertice about the subject. Because, i'm
have a customer, need's change the actual appl, but the only issue is
a dbf database, and the GUI is the older blue screen. You know, it's
ORDER BY
date_part('year', uu.add_date), date_part('month', uu.add_date),
date_part('day', uu.add_date) DESC;
You meant:
ORDER BY
date_part('year', uu.add_date) DESC, date_part('month', uu.add_date) DESC,
date_part('day', uu.add_date) DESC;
--
Scott Ribe
[EMAIL PROTECTED]
Try
SELECT DISTINCT
date_part('year', uu.add_date), date_part('month', uu.add_date),
date_part('day', uu.add_date)
FROM uus INNER JOIN ui ON uus.user_id=ui.id INNER JOIN uu ON
ui.id=uu.user_id
WHERE uus.x_id=1
ORDER BY uu.add_date DESC
The reason that your previous sort failed is that you need
On Mon, Apr 26, 2004 at 09:02:50AM -0600, Josué Maldonado wrote:
Hello Bruno and thanks for your response,
El 25/04/2004 4:59 AM, Bruno Wolff III en su mensaje escribio:
Run:
createlang plpythonu
I got this error:
createlang: language installation failed: ERROR: could not access file
On Mon, Apr 26, 2004 at 09:38:41 -0400,
[EMAIL PROTECTED] wrote:
You don't have to mess with sequences.
If there are two fields ID and year then the next number is:
next_number := ( select ID from table_name where year =
year_from_current_date order by ID desc limit 1 ) + 1;
Gee, I
We have been running Postgre for over a year and
are very pleased with its ease of use and performance.
We have encountered one problem that has been minor
until today and that is:
Occasionally a row in a table get populated with
#Deleted comments. The entire row can not be deleted.
35 matches
Mail list logo