Postgres Pro
Downloads
Home   >   mailing lists

Views with Where Clauses - Mailing list pgsql-general

From Alex
Subject Views with Where Clauses
Date
Msg-id 3F5859B5.3060808@meerkatsoft.com
Whole thread Raw
Responses Re: Views with Where Clauses  (Richard Huxton <dev@archonet.com>)
List pgsql-general
Tree view 
Hi,
I have a view that has some wher clause in it.

If I call the view with SELECT * FROM viewx WHERE xxxx ;   (joining 2
tables)
then I dont get any results back although issuing the command in full
i.e. without view i get rows back.

Is it not possible to use view that way ?

Cheers
Alex

pgsql-general by date:

Previous
From: "Amin Schoeib"
Date:
Subject: Problem with to_date/to_char
Next
From: Richard Huxton
Date:
Subject: Re: Views with Where Clauses