On 6/3/06, Chris Velevitch wrote:
On 6/2/06, Tom Lane wrote:
> "Chris Velevitch" writes:
> > I'm using pg 7.4.5 (cygwin) on win xp sp1.
> > When I enter:-
> > create view v1 as select * from t1;
> > I get:-
> > ERROR: syntax error at or near "view" at character 16
>
> Repeatably?
>
> "view" is not nearly 16 characters into that command. I think you
> typed something like
>
> junk here
> create view v1 ...
Yes, I had "explain" in front.
Why doesn't explain work with create views? There's nothing in the
documentation saying it shouldn't. If this is deliberate, the error
should state that.
Chris
--
Chris Velevitch
Manager - Sydney Flash Platform Developers Group
www.flashdev.org.au
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
