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

[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?

---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?

   http://www.postgresql.org/docs/faq

[SQL] on select rule

[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 index scan if your joining column's datatypes do not
   match

Re: [SQL] on select rule

[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 mailte Sergey Levchenko folgendes:
> > 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?
>
> With a TRIGGER.
>
>
> HTH, Andreas
> --
> Andreas Kretschmer(Kontakt: siehe Header)
> Heynitz:  035242/47215,  D1: 0160/7141639
> GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
>  ===Schollglas Unternehmensgruppe===
>
> ---(end of broadcast)---
> TIP 4: Have you searched our list archives?
>
>http://archives.postgresql.org
>

---(end of broadcast)---
TIP 6: explain analyze is your friend

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

[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 8.0, the planner will ignore your desire to
  choose an index scan if your joining column's datatypes do not
  match