[GENERAL] question on trigger

2012-02-11 Thread mgould
<<< text/html; charset="utf-8": Unrecognized >>> <>

[GENERAL] ERROR: operator does not exist: integer = character varying

2012-02-11 Thread Andreas Berglund
Hi! I have the following piece of jdbc code String query = "UPDATE books SET title = ? WHERE book_id=?"; pstmt =conn.prepareStatement(query); pstmt.setInt(1, new_book_id); pstmt.setString(2, getStringPrompt("new title")); pstmt.executeUpdate(); getStringPrompt returns a string and new_book_id i

Re: [GENERAL] ERROR: operator does not exist: integer = character varying

2012-02-11 Thread Magnus Hagander
On Sat, Feb 11, 2012 at 17:22, Andreas Berglund wrote: > Hi! > > I have the following piece of jdbc code > > String query = "UPDATE books SET title = ? WHERE book_id=?"; > pstmt =conn.prepareStatement(query); > pstmt.setInt(1, new_book_id); > pstmt.setString(2, getStringPrompt("new title")); > pst

Re: [GENERAL] question on trigger

2012-02-11 Thread Terry Lee Tucker
On Saturday, February 11, 2012 09:22:44 AM mgo...@isstrucksoftware.net wrote: > I will have several triggers which will make sure that the data in some > columns in in uppercase format. For insert it is a no brainer, however for > updates, it is better to check and see if the new values is the sa

[GENERAL] Unambiguous identification of the cluster.

2012-02-11 Thread Dmitriy Igrishin
Hey all, Is there are way to uniquely identify the cluster? May be some identificator such as UUID? PS. I need to unambiguous identify the database. There are current_catalog (and current_database()) function. There are also inet_server_addr() and inet_server_port() functions, but these functions