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
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 |