pg_views definition format

From: Kev <kevinjamesfield(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: pg_views definition format
Date: 2009-05-13 15:31:04
Message-ID: 282823aa-70d1-49e9-94e8-c1c8d46240f0@g19g2000vbi.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kevin Field 2009-05-13 16:21:16 Re: pg_views definition format
Previous Message Hans-Juergen Schoenig 2009-05-13 14:56:49 Re: SELECT ... FOR UPDATE [WAIT integer | NOWAIT] for 8.5