Re: no self-joins in views?

From: Christoph Pingel <ch(dot)pingel(at)web(dot)de>
To: Richard Huxton <dev(at)archonet(dot)com>
Cc: postgresql-general mailing list <pgsql-general(at)postgresql(dot)org>
Subject: Re: no self-joins in views?
Date: 2005-02-10 18:47:07
Message-ID: a06100505be315ac7926c@[62.224.56.43]
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>You've got two columns that the system wants to call "obj_id" here.
>Try something like
> SELECT s.obj_id AS s_obj_id, ...

That would have been elegant, but returns a 'syntax error at or near
"s_obj_id"'. Hm...

Thanks,
Christoph

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message James Thompson 2005-02-10 19:29:42 Re: Python Interface
Previous Message Christoph Pingel 2005-02-10 18:38:55 Re: no self-joins in views?