am Wed, dem 13.09.2006, um 15:46:58 -0700 mailte Junkone folgendes:
> hI
> i have a bad situation that i did not have primary key. so i have a
> table like this
> colname1colname2
> 1 apple
> 1 apple
> 2
this doesnt work
SELECT DISTINCT on link *, rank(ts_vec, to_tsquery('default', $qtxt))
FROM feed_entry WHERE ts_vec @@ to_tsquery('default', $qtxt) ORDER
BY rank(ts_vec, to_tsquery('default', $qtxt)) DESC LIMIT 5 OFFSET 0
can you tell me how to get the DISTINCT elements in LINK
thanks
Stijn
Hi,I'm looking at replacing an Oracle database that only has a few tables, but that is accessed by many programs in the company via oracle jdbc drivers, oracle odbc drivers and python database interface. Is there a way to intercept the calls to the oracle listener and redirect to postgres without c
hI
i have a bad situation that i did not have primary key. so i have a
table like this
colname1colname2
1 apple
1 apple
2 orange
2 orange
It is a very
Thanks Martijn.
Simon Kelly
Java Developer
Information Systems Development
Information Technology Shared Services
Ministry of Health
DDI:
Mobile:
http://www.moh.govt.nz
mailto:[EMAIL PROTECTED]
[EMAIL PROTECTED] wrote on 13/09/2006 01:33:15 a.m.:
> On Tue, Sep 12, 2006 at 09:51:20AM +1200,
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On 09/13/06 19:36, ljb wrote:
> [EMAIL PROTECTED] wrote:
>> hI
>> i have a bad situation that i did not have primary key. so i have a
>> table like this
>> colname1colname2
>> 1 apple
>> 1
Thanks alot Tony.
just wondering if the same can be done with C
~Jas
On 9/13/06, Tony Caduto <[EMAIL PROTECTED]> wrote:
J S B wrote:> I don't want to connect to the postgres database.>> The scenario is something like this.
>> Postgres database has to initiate some deamon process running is> anothe
snacktime wrote:
> What's a safe way to kill a specific connection to the database? I'm
> testing some code that reconnects if a connection has timed out or
> gone bad and I need to simulate a connection that has gone away.
There are various ways. The two easiest are to use iptables to block
netw
J S B wrote:
I don't want to connect to the postgres database.
The scenario is something like this.
Postgres database has to initiate some deamon process running is
another server.
The only way i could think of doing this was openeing a socket
connection between postgres database and
the d
snacktime <[EMAIL PROTECTED]> writes:
> What's a safe way to kill a specific connection to the database? I'm
> testing some code that reconnects if a connection has timed out or
> gone bad and I need to simulate a connection that has gone away.
Disconnecting a network cable might be the easiest t
What's a safe way to kill a specific connection to the database? I'm
testing some code that reconnects if a connection has timed out or
gone bad and I need to simulate a connection that has gone away.
Chris
---(end of broadcast)---
TIP 9: In versi
I think I mistakenly sent this to General
instead of Novice. Oops.
Yeah, I either skipped over or forgot the
bit in the OP about bools. Mea culpa.
You should be able to use OR instead of
AND in any logical _expression_.
Well this sounds more like what I want.
Given t2.field
didier tanti <[EMAIL PROTECTED]> writes:
> ERROR: could not load library "/myPath/libxx.so": libpcre.so : cannot open
> shared object file: No such file or directory.
> the problem is that the libpcre.so does exist and is in my
> LD_LIBRARY_PATH,
But is it in the postmaster's LD_LIBRARY_PATH?
Hello,i am desesperate to get this resolved, you are my only hope here is the issue:i am compiling a .so using:gcc -shared libxx.so -lpcre,then in my DB, i am trying:LOAD '/myPath/libxx.so',it keeps returning me :ERROR: could not load library "/myPath/libxx.so": libpcre.so : cannot open shared obje
Thanks for all the help, it works and I've learned some more about
COPY, which is treated thinly in Douglas's first edition of
"PostgreSQL" (which was my source.)
r
---(end of broadcast)---
TIP 4: Have you searched our list archives?
On 9/13/06, Brandon Aiken <[EMAIL PROTECTED]> wrote:
Ah, I did not know what was in your
fields, so I did not assume they were Boolean values. It looked to me
like you were trying to use IS TRUE to substitute for the lack of a GROUP BY,
so I didn't know what to do.That was in the fi
I use ODBC driver to access PostgresSQL 8.1 servers from Windows 98 computer
from Microsoft Visual FoxPro 9 application.
In a number of client and servers, it is not possible to send data to
server.
PostgreSQL log file shows shows that garbage characters are received.
Server
responds to thi
On Wed, 2006-09-13 at 10:05, Alban Hertroys wrote:
> Berend Tober wrote:
> > On Wed, Sep 13, 2006 at 10:56:41AM +0200, Alban Hertroys wrote:
> >
> > I'm humble (or naive) enough to admit that I've used the approach
> > outlined there by Josh Berkus, and it worked fine. More than once, even.
>
>
On 2006-09-13, Alban Hertroys <[EMAIL PROTECTED]> wrote:
> I'm quite certain that approach can be made more bullet-proof by
> wrapping it inside a transaction. I saw no mention of that on his page.
>
> It's quite amazing what PostgreSQL can handle inside transactions :)
Some of the few things tha
Berend Tober wrote:
On Wed, Sep 13, 2006 at 10:56:41AM +0200, Alban Hertroys wrote:
>
I'm humble (or naive) enough to admit that I've used the approach
outlined there by Josh Berkus, and it worked fine. More than once, even.
I'm quite certain that approach can be made more bullet-proof by
wr
On Wed, Sep 13, 2006 at 10:56:41AM +0200, Alban Hertroys wrote:
I found an oops in one of our template1 databases; tables and stuff were
apparently loaded into the wrong database (namely template1). I found
this page describing a solution:
http://techdocs.postgresql.org/techdocs/pgsqladventure
Hi, I had an application in which I used postgres 7.4, and then only thing refering to date was: datestyle = 'ISO,European'everything else was commented. Now I have had to change the OS and I've installed postgres
8.1.3, but this configuration is different, it's something like: lc_monet
On Wed, Sep 13, 2006 at 10:56:41AM +0200, Alban Hertroys wrote:
> I found an oops in one of our template1 databases; tables and stuff were
> apparently loaded into the wrong database (namely template1). I found
> this page describing a solution:
> http://techdocs.postgresql.org/techdocs/pgsqladv
Ah, I did not know what was in your
fields, so I did not assume they were Boolean values. It looked to me
like you were trying to use IS TRUE to substitute for the lack of a GROUP BY,
so I didn’t know what to do.
Yes, count() will include all non-NULL
values. Sorry if I sounded unclea
Why drop and recreate the table? Why not TRUNCATE it?
--
Brandon Aiken
CS/IT Systems Engineer
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthieu Guamis
Sent: Wednesday, September 13, 2006 6:15 AM
To: [EMAIL PROTECTED]
Subject: Re: [NOVICE] INSERT d
On Wed, 2006-09-13 at 01:51 -0400, J S B wrote:
> I don't want to connect to the postgres database.
>
> The scenario is something like this.
>
> Postgres database has to initiate some deamon process running is
> another server.
> The only way i could think of doing this was openeing a socket
>
I found an oops in one of our template1 databases; tables and stuff were
apparently loaded into the wrong database (namely template1). I found
this page describing a solution:
http://techdocs.postgresql.org/techdocs/pgsqladventuresep1.php
But, this looks kind of risky to me. I'd prefer not to
a schreef:
"select unique id" - i found this line in google search
but i want to make
select * as unique
select unique * is
or select distinct
pls point out how to select unique items from a list of million items
Maybe
select distinct from ...
or
select distinct on (field1,field2) from ...
28 matches
Mail list logo