[SQL] how to replace 0xe28093 char with another one?

2006-06-14 Thread Sergey Levchenko
hi. When I execute "SELECT specification FROM armature WHERE id = 96;" query I get WARNING: ignoring unconvertible UTF-8 character 0xe28093. How can I replace this (0xe28093) char with another one? ---(end of broadcast)--- TIP 9: In versions below

Re: [SQL] on select rule

2006-04-14 Thread Sergey Levchenko
http://www.postgresql.org/docs/8.1/interactive/sql-createtrigger.html SELECT does not modify any rows so you can not create SELECT triggers. Rules and views are more appropriate in such cases. On 4/14/06, A. Kretschmer <[EMAIL PROTECTED]> wrote: > am 13.04.2006, um 18:46:02 +0300 mail

[SQL] on select rule

2006-04-13 Thread Sergey Levchenko
Hi If I can not do insert/update action with on select rule, how can I execute some procedure or any sql statement on select event? WBR ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an i

[SQL] ERROR: "TZ"/"tz" not supported

2005-06-28 Thread Sergey Levchenko
When I execute query, I've got error message. test=> SELECT to_timestamp('00:00:05.601 SAMST Tue Jun 28 2005', 'HH24:MI:SS.MS TZ Dy Mon DD '); ERROR: "TZ"/"tz" not supported How can I convert '00:00:05.601 SAMST Tue Jun 28 2005' (varchar type) to timestamp with time zone? -