[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! Carmen ___

[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] Problem on PostgreSQL (error code, store procedures)

Hello, I would like to know if there are any global variables storing the error code or the number of rows affected after each execution of the SQL statement. Also, for Postgresql function, I have checked that I can only call the function by: select function(parms) or by EXECUTE PROCEDURE functi