Sorry, my inital e-mail was somewhat vague. Here's another attempt.
create view sun_r as select freemem, freeswap, time, systemid
from sardata where systemid in (select sysid from systems where platform =
'sun') and datatype = 'r' with check option;
Above is a copy of one of the views I'm trying to create. The view, sun_r,
does a select against sardata. The 'check option' is at the end as you can
see. From what few examples I have seen, this would be okay. However I
get a parse error when using the 'with check option'. Any ideas?
Travis Hoyt wrote:
> Anyone able to get this to work? I keep getting parse errors. If you
> have it working, can you send me an example? Couldn't find anything on
> the web page docs.
pgsql-novice by date
|Next:||From: Mark McArthey||Date: 2001-10-23 19:25:31|
|Subject: column length?|
|Previous:||From: Mark McArthey||Date: 2001-10-23 17:36:28|
|Subject: dynamic #include's?|