Sandra Arnold wrote:
We are in the process of migrating from Oracle to PostgreSQL.
One of the things that we are needing to find out is what to
use in place of Oracle supplied functionality such as
DBMS_OUTPUT and UTL_FILE. We are currently using this
type of functionality in Stored
Hello!
Thank you very much for your answer. I try to use gdb now. But there is a
little difficulty. I'm not quite sure it is connected with postgres build.
Probably I do something wrong using gdb but maybe you could show me the
direction for resolving the problem?
I built PostgreSQL 8.4
Лучшие предложения интернет-магазинов на Това�...@mail.ru
http://r.mail.ru/cln4267/torg.mail.ru/
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
-Original Message-
From: el dorado do_ra...@mail.ru
To: pgsql-general@postgresql.org
Date: Fri, 18 Sep 2009 15:24:24 +0400
Subject: [GENERAL] Build PG 8
Sorry, the previous letter was sent by mistake.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make
Hello!
I need to build PG 8.4 from sources for WinXP. There are two ways to do it: by
means of MinGW of by means of MSVC. Firstly I used MinGW (gcc), but
unfortunately I noticed some problems with result biniries (f.e.
http://archives.postgresql.org/pgsql-general/2009-09/msg00526.php).
What is
2009/9/18 el dorado do_ra...@mail.ru:
Hello!
I need to build PG 8.4 from sources for WinXP. There are two ways to do it:
by means of MinGW of by means of MSVC. Firstly I used MinGW (gcc), but
unfortunately I noticed some problems with result biniries (f.e.
On Thu, Sep 3, 2009 at 3:44 AM, Allan Kamau kamaual...@gmail.com wrote:
Hi,
I do have a query which make use of the results of an aggregate
function (for example bit_or) several times in the output column list
of the SELECT clause, does PostgreSQL simply execute the aggregate
function only
Merlin Moncure mmonc...@gmail.com writes:
On Thu, Sep 3, 2009 at 3:44 AM, Allan Kamau kamaual...@gmail.com wrote:
I do have a query which make use of the results of an aggregate
function (for example bit_or) several times in the output column list
of the SELECT clause, does PostgreSQL simply
Hi,
Please consider the following query.
The reftable inner query generates a table with 11 elements, 7 of them
having the groupkey 1, and the 4 others the groupkey 2. This set is then
grouped by the groupkey field, and after that a generate_series and a
sequence are used to create an ordered id.
Raymond O'Donnell wrote:
On 16/09/2009 10:55, Howard Cole wrote:
Hi All,
I have been having a few problems with my password file recently,
causing my scheduled pg_dump to fail. The problem is that the
pgpass.conf file keeps changing. Eventually I narrowed it down to using
pgadmin. Every
On Fri, Sep 18, 2009 at 10:00 AM, Picavet Vincent
vincent.pica...@mediapost.fr wrote:
Hi,
Please consider the following query.
The reftable inner query generates a table with 11 elements, 7 of them
having the groupkey 1, and the 4 others the groupkey 2. This set is then
grouped by the
On 18/09/2009 16:07, Howard Cole wrote:
Thanks for the update. Unfortunately this behaviour has the side effect
of deleting passwords that I have set up in the file manually for other
applications (namely the backup), which runs under the same user
account. I guess I'll just have to come up
Raymond O'Donnell wrote:
On 18/09/2009 16:07, Howard Cole wrote:
Thanks for the update. Unfortunately this behaviour has the side effect
of deleting passwords that I have set up in the file manually for other
applications (namely the backup), which runs under the same user
account. I guess
I have a table with
name_first
name_middle
name_last
if i try concatenating as such:
SELECT
name_first || ' ' || name_middle || ' ' || name_last
FROM
mytable
;
I end up with NULL as the concatenated string whenever
On 18/09/2009 16:52, Jonathan Vanasco wrote:
I have a table with
name_first
name_middle
name_last
if i try concatenating as such:
SELECT
name_first || ' ' || name_middle || ' ' || name_last
FROM
mytable
;
I end up with NULL as the concatenated
Hello, I would like to create with several tables but each table will have 2
fields, LASTUSERID LASTUPDATEDATETIME. My quest is:
Is there any way to create these 2 fields and then use them in all tables?
Please help the soonest table.
Thanks in advance
Elias
--
View this message in context:
On 18 Sep 2009, at 18:25, Raymond O'Donnell wrote:
On 18/09/2009 16:52, Jonathan Vanasco wrote:
I have a table with
name_first
name_middle
name_last
if i try concatenating as such:
SELECT
name_first || ' ' || name_middle || ' ' || name_last
FROM
mytable
;
I
On Thu, Sep 17, 2009 at 10:06 AM, Marco Fortina marco.fort...@bsc.it wrote:
Hello there!
A customer of our company would like to create a 2 nodes cluster connected
to an external NAS storage. I would like to know if PostgreSQL supports its
datafiles on this kind of storage and if this
ekekakos wrote:
Hello, I would like to create with several tables but each table will have 2
fields, LASTUSERID LASTUPDATEDATETIME. My quest is:
Is there any way to create these 2 fields and then use them in all tables?
Please help the soonest table.
Thanks in advance
Elias
No. Perhaps you
On Thu, 17 Sep 2009, Marco Fortina wrote:
A customer of our company would like to create a 2 nodes cluster
connected to an external NAS storage. I would like to know if PostgreSQL
supports its datafiles on this kind of storage and if this solution is
certified.
It's possible to setup this
On Thu, 17 Sep 2009, Jonathan wrote:
Invalid query: ERROR: column distance does not exist LINE
1: ...ude ) ) ) ) AS distance FROM aaafacilities HAVING distance ...
^
You can't use distance in a HAVING clause if distance is computed as part
of the query result. You can rewrite this to use a
And I think that might work for you. The performance is going to be
miserable for large stat sets, because it's going to scan the whole
aaafacilities table every time and recompute every distance, but as an
example goes it's probably acceptable.
Something I did when implementing haversine in
Trevor ,
If you have just a need to install and use Windows Server
2003 , you can do that one easily . Just install it go to data
directory modify conf files
Vikram
On Sep 14, 5:43 pm, trevor.john...@tafensw.edu.au (Johnson, Trevor)
wrote:
Hi
I'm new to PostgreSQL and I'm looking for
Is there a way to return a percentage of the rows found? I tried
window functions but get an error...
ERROR: syntax error at or near OVER
SELECT id, cume_dist FROM (
SELECT id, cume_dist() OVER (ORDER BY id) FROM employees
) s
WHERE cume_dist 0.3
--
Sent via pgsql-general mailing list
Nick wrote on 18.09.2009 23:31:
Is there a way to return a percentage of the rows found? I tried
window functions but get an error...
ERROR: syntax error at or near OVER
SELECT id, cume_dist FROM (
SELECT id, cume_dist() OVER (ORDER BY id) FROM employees
) s
WHERE cume_dist 0.3
Works for
I can't install the 8.2.14 or 8.4.1 source rpms:
# rpm -Uhv postgresql-8.2.14-1PGDG.f11.src.rpm
warning: postgresql-8.2.14-1PGDG.f11.src.rpm: Header V4 DSA signature:
NOKEY, key ID 442df0f8
1:postgresql warning: user devrim does not exist - using root
warning: group devrim does not
Hi Clodoaldo,
On Fri, 2009-09-18 at 19:42 -0300, Clodoaldo Neto wrote:
# rpm -Uhv postgresql-8.2.14-1PGDG.f11.src.rpm
warning: postgresql-8.2.14-1PGDG.f11.src.rpm: Header V4 DSA signature:
NOKEY, key ID 442df0f8
1:postgresql warning: user devrim does not exist -
using root
//Display the top 40 % of rows in BB_DEPARTMENT
SQL select ROWNUM,ID FROM EMPLOYEES WHERE ROWNUM .3*(SELECT COUNT(ID) FROM BB
_DEPARTMENT) GROUP BY ROWNUM,ID;
ROWNUM
--
1
HTH
Martin Gainty
__
Verzicht und
On Fri, Sep 18, 2009 at 07:54:30PM -0400, Martin Gainty wrote:
//Display the top 40 % of rows in BB_DEPARTMENT
SQL select ROWNUM,ID FROM EMPLOYEES WHERE ROWNUM .3*(SELECT COUNT(ID) FROM
BB
_DEPARTMENT) GROUP BY ROWNUM,ID;
ROWNUM
--
1
HTH
Martin Gainty
That's
2009/9/18 Devrim GÜNDÜZ dev...@gunduz.org:
Hi Clodoaldo,
On Fri, 2009-09-18 at 19:42 -0300, Clodoaldo Neto wrote:
# rpm -Uhv postgresql-8.2.14-1PGDG.f11.src.rpm
warning: postgresql-8.2.14-1PGDG.f11.src.rpm: Header V4 DSA signature:
NOKEY, key ID 442df0f8
1:postgresql
30 matches
Mail list logo