| From: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
|---|---|
| To: | "McCaffity, Ray (Contractor)" <McCaffityR(at)epg(dot)lewis(dot)army(dot)mil> |
| Cc: | "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: newbie - syntax question |
| Date: | 2002-05-10 00:42:42 |
| Message-ID: | 20020509174129.D25908-100000@megazone23.bigpanda.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Nigel J. Andrews | 2002-05-10 00:48:46 | Re: trouble with (lack of) indexing |
| Previous Message | Tom Lane | 2002-05-10 00:42:37 | Re: trouble with (lack of) indexing |