On Mon, 24 Nov 2003, Klint Gore wrote:
> I've got the message "ERROR: variable not found in subplan target lists"
> when I have a union between 2 views. Both selects from the views run
> without the union. Same result using intersect and except. Same result
> using any of them with the all qu
I've got the message "ERROR: variable not found in subplan target lists"
when I have a union between 2 views. Both selects from the views run
without the union. Same result using intersect and except. Same result
using any of them with the all qualifier. Explain of the union gives
the error, e
"Douglas M. Westfall" <[EMAIL PROTECTED]> writes:
> 1) table contains a valid inet field
> 2) query works fine in pgsql 7.2 & 7.3
> 3) query no longer works in pgsql 7.4
> select * from where ilike '%%' ;
> ERROR: Unable to identify an operator '~~*' for types 'inet' and '"unknown"'
>
jerry <[EMAIL PROTECTED]> writes:
> What is the possiblity that I would encounter this error if I were to remove
> the 7.3.4 RPMs and install the 7.4 tar files manually?
Mere presence of the 7.3 RPMs would not trigger this error. However, if
you are trying to run 7.3 and 7.4 postmasters concurren
Andrew Holm-Hansen <[EMAIL PROTECTED]> writes:
> ERROR: variable not found in subplan target list
What PG version is this? We've fixed a number of bugs with that
symptom, IIRC ...
regards, tom lane
---(end of broadcast)---
On Sat, 22 Nov 2003, Douglas M. Westfall wrote:
> Yes, I have searched the archives, and searches for 'inet' or 'ilike' or
> 'inet+ilike' and 'inet&ilike' return 0 results each.
>
> Have I missed something?
I believe your problem is that you were relying on a cast from inet to
text (on which ilik
