Skip site navigation (1) Skip section navigation (2)

Re: create view bug

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Jefim Matskin <mjefim(at)sphera(dot)com>, pgsql-bugs(at)postgresql(dot)org
Subject: Re: create view bug
Date: 2001-09-05 21:15:49
Message-ID: 200109052115.f85LFnt07107@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
This feature will appear in 7.2:

	test=> create view aaa (x) as select relname from pg_class;
	CREATE
	test=> select * from aaa;
	                x                
	---------------------------------
	 pg_type
	 pg_attribute


> > My problem is that the  ErWin generates the following syntax
> > create view [view name] ( [col1] , [col2] ) as select [s1], [s2]  from
> > [table name];
> > and as far as I know this is SQL92.
> 
> (checks spec...) You're right, SQL92 does require this syntax.  Okay,
> I'll put it on the to-do list.
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> message can get through to the mailing list cleanly
> 

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

In response to

Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2001-09-05 21:35:31
Subject: Re: create view bug
Previous:From: Steve PothierDate: 2001-09-05 19:45:16
Subject: parse error: LIMIT combined with UNION

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group