On May 13, 11:31 am, Kev <kevinjamesfi...@gmail.com> wrote:
> Hi,
>
> I have a script that automatically generates the SQL to create some
> views. I'd like it to check whether its generated SQL matches the SQL
> returned by "select definition from pg_views where...". I've guessed
> most of the rules just by looking at the output, but I was surprised
> to find that some of my views of the form:
>
> select.........from b left join a on a.id=b.id
>
> ...were being translated to this:
>
> SELECT..........FROM (B LEFT JOIN a ON ((a.id = b.id)))
>
> ...before being stored in the table pg_views is derived from. My
> surprise is at the double parentheses around "a.id = b.id". Is that
> supposed to be that way? Is it likely to change?
>
> Thanks,
> Kev
One other thing I'm just curious about, "!=" gets replaced with
"<>"...how come? (Feels more VB-ish than C-ish, so I was surprised
that that would be the official/preferred reconstruct....)