[SQL] Speed depending of Join Order.

2003-01-21 Thread Raúl Gutiérrez Sánchez
I will explain my question usin an example. I have two tables as follows: Table "public.image_mode" Column| Type | Modifiers -+---+--- mis_id | character(5) | not null ins_id | character(5) | not null img_id | character(2

[SQL] [OT] Unsubscribe does not work

2003-01-21 Thread Andreas Tille
Hi, once I subscribed to this list I've got the information how to subscribe: If you ever want to remove yourself from this mailing list, send the following command in email to [EMAIL PROTECTED]: approve unsubscribe Andreas Tille <[EMAIL PROTECTED]> Well, I did so but I'm still rec

[SQL] performance question

2003-01-21 Thread Moritz Lennert
Hello, I have a table with some 2.2 million rows on a Pentium4, 1.8GHz with 512 MB RAM. Some queries I launch take quite a long time, and I'm wondering whether this is normal,or whether I can get better performance somehow. As an example, I have a field which is in char(2), with 23 different poss

[SQL] returning setof in plpgsql

2003-01-21 Thread David Durst
I have a function that I want to return setof a table in plpgsql. Here is what I have: CREATE FUNCTION lookup_account(varchar(32)) RETURNS SETOF accounts AS ' DECLARE aname ALIAS FOR $1; rec RECORD; BEGIN select into rec * from accounts where accountname = aname; return rec; END;' LANGUAG

Re: [SQL] [OT] Unsubscribe does not work

2003-01-21 Thread Bruno Wolff III
On Tue, Jan 21, 2003 at 14:23:02 +0100, Andreas Tille <[EMAIL PROTECTED]> wrote: > Hi, > > once I subscribed to this list I've got the information how to > subscribe: > >If you ever want to remove yourself from this mailing list, >send the following command in email to >[EMAIL PROTE

Re: [SQL] [OT] Unsubscribe does not work

2003-01-21 Thread Andreas Tille
On Tue, 21 Jan 2003, Bruno Wolff III wrote: > What response did you get to your message? No response at all. > I usually use [EMAIL PROTECTED] as the address to send mailing > list commands to, though it is possible the address you tried works > as well. I normally send those command to majordomo

Re: [SQL] returning setof in plpgsql

2003-01-21 Thread Gary Stainburn
On Tuesday 21 Jan 2003 10:40 am, David Durst wrote: > I have a function that I want to return setof a table in plpgsql. > > Here is what I have: > > CREATE FUNCTION lookup_account(varchar(32)) RETURNS SETOF accounts AS ' > DECLARE > aname ALIAS FOR $1; > rec RECORD; > BEGIN > select into rec

Re: [SQL] [OT] Unsubscribe does not work

2003-01-21 Thread Tom Lane
Bruno Wolff III <[EMAIL PROTECTED]> writes: > I usually use [EMAIL PROTECTED] as the address to send mailing > list commands to, though it is possible the address you tried works > as well. majordomo worked the last time I tried it. Rather than unsubscribing (and losing all your settings) I'd sug

Re: [SQL] Speed depending of Join Order.

2003-01-21 Thread Tom Lane
=?iso-8859-1?Q?Ra=FAl=20Guti=E9rrez=20S=E1nchez?= <[EMAIL PROTECTED]> writes: > Note that the only difference is the order of the join elements. Using > version 7.2.2, which I have been using untill now, the time expended in > both of them was the same, using the right indexes. However, using > ver

Re: [SQL] returning setof in plpgsql

2003-01-21 Thread Tom Lane
"David Durst" <[EMAIL PROTECTED]> writes: > CREATE FUNCTION lookup_account(varchar(32)) RETURNS SETOF accounts AS ' > DECLARE > aname ALIAS FOR $1; > rec RECORD; > BEGIN > select into rec * from accounts where accountname = aname; > return rec; > END;' > LANGUAGE 'plpgsql'; As written, thi

[SQL] help

2003-01-21 Thread Rudi Starcevic
help ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

[SQL] Oops - help error.

2003-01-21 Thread Rudi Starcevic
Sorry .. My apologies I clicked too quick too early .. Please disregard my help request to the wrong address .. Promise it won't happen again .. Thanks for everything Best Regards Rudi. ---(end of broadcast)--- TIP 1: subscribe and unsubscribe comm