This sounds like a perfect candidate for a LEFT OUTER JOIN. See:
http://www.postgresql.org/docs/7.4/static/queries-table-
expressions.html#QUERIES-FROM
Yours would looks something like:
SELECT *
FROM ...
LEFT JOIN candidate AS c
ON <...>.omcr_id = c.omcr_id
AND ...
-tfo
--
Thomas F. O'Connell
Co-
My outer query to get the candidates has an outer join, that works
just fine and I get the null OMCR_ID's.
It's when I have to query the dimension table (no joins) to see if a
row exists with a (sometimes) null OMCR_ID I'm forced to write 2
queries, when I think I should only have to write one.
T
As far as I know, you didn't post your actual table definitions (or
full queries) earlier, so I'm not exactly sure what you mean.
-tfo
--
Thomas F. O'Connell
Co-Founder, Information Architect
Sitening, LLC
http://www.sitening.com/
110 30th Avenue North, Suite 6
Nashville, TN 37203-6320
615-260-00
On Sun, 30 Jan 2005, Don Drake wrote:
> OK, I have a function that finds records that changed in a set of
> tables and attempts to insert them into a data warehouse.
>
> There's a large outer loop of candidate rows and I inspect them to see
> if the values really changed before inserting.
>
> My
Dear Friends
how i can increse the number of commands in an transaction block
i use postgres 7.4.5 on linux
Regards
Luiz
- Original Message -
From: "Stephan Szabo" <[EMAIL PROTECTED]>
To: "Don Drake" <[EMAIL PROTECTED]>
Cc:
Sent: Monday, January 31, 2005 7:31 PM
Subject: Re: [SQL] plpgsql
On Mon, Jan 31, 2005 at 07:54:45PM -0200, Luiz Rafael Culik Guimaraes wrote:
>
> how i can increse the number of commands in an transaction block
What do you mean? What problem are you trying to solve?
--
Michael Fuhr
http://www.fuhr.org/~mfuhr/
---(end of broadcast)---
You learn something new everyday. I've never seen that syntax before,
and it works like a charm!!
Thanks a ton.
-Don
On Mon, 31 Jan 2005 13:31:34 -0800 (PST), Stephan Szabo
<[EMAIL PROTECTED]> wrote:
>
> On Sun, 30 Jan 2005, Don Drake wrote:
>
> > OK, I have a function that finds records tha
Hi Michael Fuhr
how i can increse the number of commands in an transaction block
What do you mean? What problem are you trying to solve?
i´m trying to solve the follow message
current transaction is aborted, queries ignored until end of transaction
block
some one tell me this is defined inside pos
On Mon, 2005-01-31 at 16:29, Luiz Rafael Culik Guimaraes wrote:
> Hi Michael Fuhr
> >> how i can increse the number of commands in an transaction block
> >
> > What do you mean? What problem are you trying to solve?
>
> iÂm trying to solve the follow message
> current transaction is aborted, quer
On Mon, Jan 31, 2005 at 08:29:42PM -0200, Luiz Rafael Culik Guimaraes wrote:
>
> i´m trying to solve the follow message
> current transaction is aborted, queries ignored until end of transaction
> block
A previous command in the transaction has failed; no more commands
will be executed until you
On Mon, 31 Jan 2005, Don Drake wrote:
> You learn something new everyday. I've never seen that syntax before,
> and it works like a charm!!
Actually, now that I think about it, I wonder if that's a good thing to
use because I don't think that'll use indexes to do the search. You may
want to do
I'm constraining on other columns as well and it's still picking up the index.
Thanks again.
-Don
On Mon, 31 Jan 2005 16:32:02 -0800 (PST), Stephan Szabo
<[EMAIL PROTECTED]> wrote:
> On Mon, 31 Jan 2005, Don Drake wrote:
>
> > You learn something new everyday. I've never seen that syntax befo
Hi,
Apologies if I've already sent a post asking this but I'm not sure if it
actually went through last time as it doesn't seem to be in my sent
items box.
Anyway, I was wondering which would be a better way to store a large
amount of files each a few megabytes in size. There could be hundreds of
Don Drake <[EMAIL PROTECTED]> writes:
> On Mon, 31 Jan 2005 16:32:02 -0800 (PST), Stephan Szabo
> <[EMAIL PROTECTED]> wrote:
>> Actually, now that I think about it, I wonder if that's a good thing to
>> use because I don't think that'll use indexes to do the search. You may
>> want to do some test
Sam Adams wrote:
Anyway, I was wondering which would be a better way to store a large
amount of files each a few megabytes in size. There could be hundreds of
thousands of files altogether. If stored as BYTEAs this would put them
all in a single table. Would this effect performance considerablely?
Hi,
What you could do is create a table containing all the fields from your SELECT,
plus a per-session unique ID. Then you can store the query results in there,
and use SELECT with OFFSET / LIMIT on that table. The WHERE clause for this
temp-results table only needs to contain the per-session u
Quoting Dennis Sacks <[EMAIL PROTECTED]>:
> Bruno Wolff III wrote:
> >On Tue, Jan 25, 2005 at 21:21:08 -0700,
> > Dennis Sacks <[EMAIL PROTECTED]> wrote:
> >>One of the things you'll want to do regularly is run a "vacuum analyze".
> >>You can read up on this in the postgresql docs. This is essent
PostgreSQL 8.0.0 on WinXP Pro, libpq
In my hands it looks like a user with INSERT/DELETE/UPDATE rights on table1
cannot do "update table1 set field1=xx where field2=yy" without also being
granted select rights. However, the user can do "update table1 set field1=xx".
Is this right? Any explanations
Hi... People
I would like to know if inside of a function that has been called by
a trigger, what instruction the SQL called, i do not wanna know if it´s
a insert or a update or a delete (tg_op)... i need the full instruction.
For example:
I wanna know the number of the instruction:
update te
Hi, I need a script or a program that convert and
esport my data from sql database to a file in the iso2709 format
thanks
bye
Hi,
i have a problem with the following
sentence:
CREATE OR REPLACE FUNCTION
tschema.sp_actualizar_contacto(p_idpers
text,
p_nombre
text,
p_apellido
text,
Hi PFC
Thanks for this! It has sped up complete - now in fact there is no delay!
A few tweaks had to be made to the code ; here it is:
select breakdown.alignment, sum(cnt) as num FROM
( (select alignment.name as class, count(1) as cnt
from weapons,
alignment
where weapons
On Jan 31, 2005, at 1:59 PM, Ing. Jhon Carrillo wrote:
ERROR: function tschema.sp_actualizar_contacto(integer, "unknown",
"unknown", "unknown", "unknown", "unknown", "unknown", integer,
"unknown", "unknown", "unknown", "unknown", "unknown", "unknown",
"unknown", "unknown", "unknown", "unknown",
hi,
I'm not familiar with iso2709 but there is a program called Octopus that may do what
you want. It's open source software and can be found at octopus.enhydra.org -
worth a try anyway.
Regards
Iain
- Original Message -
From:
Matteo
Braidotti
To: pgsql-sql@postgres
[EMAIL PROTECTED] writes:
> In my hands it looks like a user with INSERT/DELETE/UPDATE rights on table1
> cannot do "update table1 set field1=xx where field2=yy" without also being
> granted select rights. However, the user can do "update table1 set field1=xx".
> Is this right?
Yes. Otherwise you
O Dennis Sacks έγραψε στις Jan 31, 2005 :
> Sam Adams wrote:
>
> >Anyway, I was wondering which would be a better way to store a large
> >amount of files each a few megabytes in size. There could be hundreds of
> >thousands of files altogether. If stored as BYTEAs this would put them
> >all in a
As I read the docs, a temp table doesn't solve our problem, as it does
not persist between sessions. With a web page there is no guarentee
that you will receive the same connection between requests, so a temp
table doesn't solve the problem. It looks like you either have to
create a real table (w
27 matches
Mail list logo
