On Sun, Jan 02, 2005 at 01:58:20 -0500,
Madison Kelly <[EMAIL PROTECTED]> wrote:
> Bruno Wolff III wrote:
> >SELECT a_name, a_type, a_dir, a_ FROM table_a
> > WHERE a_name, a_type, a_dir NOT IN (
> >SELECT b_name, b_type, b_dir FROM table_b)
> >;
> >
> >In pre 7.4 versions or if there are NU
Bruno Wolff III wrote:
SELECT a_name, a_type, a_dir, a_ FROM table_a
WHERE a_name, a_type, a_dir NOT IN (
SELECT b_name, b_type, b_dir FROM table_b)
;
In pre 7.4 versions or if there are NULLs in the key columns for table_b
then you probably want to use NOT EXISTS (with a moodified WHERE clau
Vincent Hikida wrote:
There are several ways. I am making the simplifying assumption that
name, type and dir cannot be NULL in either table. If they are the query
is a little more complicated.
The following are a couple of many techniques.
SELECT a.a_name
, a.a_type
, a.a
Pierre-Frédéric Caillaud wrote:
Is your authentication set to "Trust" in the config files ?
On Fri, 31 Dec 2004 08:45:34 -0600, Eric Scott
<[EMAIL PROTECTED]> wrote:
Heya;
I have PostGreSQL 7.3.4 on Mandrake Linux 9.2. For some reason
Webmin, when I tell it to change the password of a pgs
On Sun, Jan 02, 2005 at 01:31:22AM +, Oluwatope Akinniyi wrote:
> I tried to create a function with about 60 input parameters and got an
> error message that a function cannot take more than 32 parameters.
What's the function's purpose? Why does it need so many arguments?
You might be able
On Sat, Jan 01, 2005 at 22:32:17 -0500,
Madison Kelly <[EMAIL PROTECTED]> wrote:
> Hi all,
>
> This is my first post here so please let me know if I miss any list
> guidelines. :)
>
> I was hoping to get some help, advice or pointers to an answer for a
> somewhat odd (to me at least) SELE
There are several ways. I am making the simplifying assumption that name,
type and dir cannot be NULL in either table. If they are the query is a
little more complicated.
The following are a couple of many techniques.
SELECT a.a_name
, a.a_type
, a.a_dir
FROM a_table
Hi all,
This is my first post here so please let me know if I miss any list
guidelines. :)
I was hoping to get some help, advice or pointers to an answer for a
somewhat odd (to me at least) SELECT. What I am trying to do is select
that values from one table where matching values do not exis
On Sun, 2004-12-12 at 20:25 -0800, Lonni J Friedman wrote:
> OK, thanks. So is there any real benefit in doing this in a generic
> (non-dspam) sense, or is it just a hack that wouldn't be noticable?
> Any risks or potential problems down the line?
>
>
I'd just like to add that some 3rd party a
For what it's worth, I put 100k rows into a table in 8.0beta5, and
selected 10k at a time. When doing each SELECT seperately using the
index, it took about 2.5s to do 10k SELECTs. When using an IN query
containing all the id's that I wanted, it took less than a second.
Jeff
On Sat, 2005-01-01 at
Well, first it would be a good idea to see what postgres is actually
doing. Send the output of:
=> EXPLAIN ANALYZE SELECT OID FROM atrikelindex WHERE id_artikel=?;
(where ? is replaced by some id value)
It will either say index lookup or sequential scan since it's just a
select from one table. T
Hi,
Compliments of the season.
I tried to create a function with about 60 input parameters and got an
error message that a function cannot take more than 32 parameters.
Is there a way around this? Or Am I in error?
Best regards.
Tope
--
---(end of broadcast)--
psql8:
I use a bigger psql-table to store information and keep an id-value of
each row in memory of my application for faster access.
My applications is able to calculate a list of needed id's in very short
time and then wants to retrieve all rows corresponding to this id's.
So in fact I perform
Hi Michael,
I'll try and get a nice small pared-down source for you to play with that
demonstrates the problem. Once I get that, I could certainly try rc3,
although I was hoping to wait for the RPM...
John.
-Original Message-
From: Michael Meskes [mailto:[EMAIL PROTECTED]
Sent: 01 Janu
Intresting.
What is the size when bytea become inafective ?
Currently i keep all my products images in bytea record. is it
practical ?
Well I am going to make the assumption that you product images are small...
sub 100k or something. Bytea is just fine for that. The problem is when
the binary yo
On Sat, Jan 01, 2005 at 01:28:04PM +0300, Michael Ben-Nes wrote:
> Joshua D. Drake wrote:
> >Frank D. Engel, Jr. wrote:
> >>I'd advise use of BYTEA as well. It's much simpler to work with than
> >>the OIDs, and has simpler semantics. You do need to escape data
> >>before handing it to the query
On Tue, Dec 28, 2004 at 10:16:04PM -, John Smith wrote:
> I'm trying to convert a series of C programs written originally using
> Informix ESQL to use Postgres' ECPG.
> ...
> 575 EXEC SQL connect to pdev_changename;
> ...
> I'm using Postgres 8.0.0rc1 on Redhat 9 (kernel 2.4.20-31.9
has no one been able to solve this problem?
-Original Message-
From: [EMAIL PROTECTED] on behalf of Jason Tesser
Sent: Thu 12/30/2004 9:30 PM
To: pgsql-general@postgresql.org
Subject: [GENERAL] pgodbc error
In my postgresql.conf I set it to log the query durations and this seems to
goo
Joshua D. Drake wrote:
Frank D. Engel, Jr. wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I'd advise use of BYTEA as well. It's much simpler to work with than
the OIDs, and has simpler semantics. You do need to escape data
before handing it to the query string, and handle escaped results
19 matches
Mail list logo
