| From: | Alex <alex(at)meerkatsoft(dot)com> |
|---|---|
| To: | Richard Huxton <dev(at)archonet(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Views with Where Clauses |
| Date: | 2003-09-05 10:59:37 |
| Message-ID: | 3F586C99.6080902@meerkatsoft.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
My apologies...
I had a Limit in the view. So, the second where never got to a valid
record.
Thanks anyway
A
Richard Huxton wrote:
>On Friday 05 September 2003 10:39, Alex wrote:
>
>
>>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 ?
>>
>>
>
>That's how they're supposed to work. Are you sure there's not some subtle
>mistake in the view definition? Feel free to post it along with the query.
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | shreedhar | 2003-09-05 11:26:23 | How can I set postmaster as a service |
| Previous Message | Csaba Nagy | 2003-09-05 10:46:02 | Re: Replaceing records |