2009/9/18 Devrim GÜNDÜZ :
> 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: use
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 Ga
//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 Vertraulichkeitanmerk
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 r
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
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 f
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 (p
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
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
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
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 co
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, Sep 17, 2009 at 10:06 AM, Marco Fortina 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 solution is certified
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 end
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/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
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 a
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.
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 u
On Fri, Sep 18, 2009 at 10:00 AM, Picavet Vincent
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 groupkey field, and after that
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 time
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.
Merlin Moncure writes:
> On Thu, Sep 3, 2009 at 3:44 AM, Allan Kamau 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 execute the aggregate
>> function
On Thu, Sep 3, 2009 at 3:44 AM, Allan Kamau 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 once and provide t
2009/9/18 el dorado :
> 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/
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 r
-Original Message-
From: el dorado
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 changes to your subsc
Лучшие предложения интернет-магазинов на Това�...@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
> 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
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 St
30 matches
Mail list logo
