[SQL] Poor performance on a right join

g so long? What can I do to help the performance? Thanks in advance, Carmen ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Problem on PostgreSQL (error code, store procedures)

function(parms) in the trigger action. I wonder whether there is any other method for calling the function which is similar to the stored procedures in the MS SQL server? Thank a lot! Carmen __ Do You Yahoo!? Sign up for SBC Yahoo! Dial - First Month

[SQL] No command history in psql

Hello: I am upgrading to postgresql version 7.2.1. I found that the psql has not included the readline library automatically and doesn't have any readline and history command function. So I configure the postgresql with option --with-includes=/usr/local/include and --with-libs=/usr/libs/ so th

[SQL] Case in-sensitive

Hello: Can I config the Postgresql so that it can match case in-sensitive pattern automatically? i.e. I don't need to explicit convert the pattern to lower case like this: .WHERE lower(textfield) LIKE lower(pattern) Thanks a lot! C

[SQL] vacuum and serial primary keys

ght I have only 2 rows in my table they have the ID 3001 and 3002. Is this normal ? If not could someone please explain me how could I reset the "counter" to ignore the deleted rows ? Thank you very much Carmen ---(end of broadcast)---