On Thu, 9 May 2002, McCaffity, Ray (Contractor) wrote:
> We are in the process of switching from Ingres II to Postgres,
> we use a lot of views, most of them seem to straight across without too
> many problems. But some are a little more diffcult. Does anyone know
> the syntax, on how to do view aliasing in postgres? Here is an example
> view script from ingres. I've looked all through the PDF manuals, and I can
> create generic views, but these don't seem to work. This one seems to fail
> with all of the "=" .
> select distinct
> uid = 'c' + trim(char(m.ctc_uid)),
> command = e.msg_command,
I think you probably want something like
e.msg_command AS command,