Postgres Pro
Downloads
Home   >   mailing lists

Re: [SQL] primary key view failure - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] primary key view failure
Date
Msg-id 4102.933863176@sss.pgh.pa.us
Whole thread Raw
In response to primary key view failure  (rob caSSon <rob@styro.lib.muohio.edu>)
Responses Re: [SQL] primary key view failure  (rob caSSon <rob@styro.lib.muohio.edu>)
Re: [SQL] primary key view failure  ("Ross J. Reedstrom" <reedstrm@wallace.ece.rice.edu>)
List pgsql-sql
Tree view 
rob caSSon <rob@styro.lib.muohio.edu> writes:
> i have a perfectly valid sql statement that returns expected results, but
> when i create a view based on the same sql, i get 0.

Your example seems to work fine for me with current sources.
What version are you running?
        regards, tom lane

pgsql-sql by date:

Previous
From: Patrick Giagnocavo
Date:
Subject: Re: [SQL] qurey plan and indices
Next
From: Tom Lane
Date:
Subject: Re: [SQL] qurey plan and indices