On May 13, 5:37 pm, gsm...@gregsmith.com (Greg Smith) wrote:
On Wed, 13 May 2009, Kevin Field wrote:
Or would the only way to do this be to actually create a view and then
call pg_get_viewdef() and then delete the view?
Just make it a temporary view and then it drops when the session ends.
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
Kevin Field kevinjamesfi...@gmail.com wrote:
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)
is the SQL standard operator. != is a PostgreSQL extension,
Kevin Field wrote:
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)
is the official SQL standard notation for not equals, AFAIK. != is not.
cheers
Kev kevinjamesfi...@gmail.com writes:
... 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
On May 13, 12:41 pm, kevin.gritt...@wicourts.gov (Kevin Grittner)
wrote:
Kevin Field kevinjamesfi...@gmail.com wrote:
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
On May 13, 12:52 pm, t...@sss.pgh.pa.us (Tom Lane) wrote:
Kev kevinjamesfi...@gmail.com writes:
... 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 =
On Wed, 13 May 2009, Kevin Field wrote:
Or would the only way to do this be to actually create a view and then
call pg_get_viewdef() and then delete the view?
Just make it a temporary view and then it drops when the session ends.
Here's a working shell example that transforms a view into the