pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Insert into VIEW ???
2+ messages / 2 participants
[nested] [flat]

* Insert into VIEW ???
@ 2001-02-28 23:29 Jacek Zagorski <jaz@shastanetworks.com>
  2001-03-03 15:13 ` Re: Insert into VIEW ??? Richard Huxton <dev@archonet.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Jacek Zagorski @ 2001-02-28 23:29 UTC (permalink / raw)
  To: pgsql-sql


Is it possible to INSERT into xyz
where xyz is a view ?
What is the proper syntax ?

Thanks Much
Jacek Zagorski
Shasta NetWorks LLC
jaz@shastanetworks.com




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: Insert into VIEW ???
  2001-02-28 23:29 Insert into VIEW ??? Jacek Zagorski <jaz@shastanetworks.com>
@ 2001-03-03 15:13 ` Richard Huxton <dev@archonet.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Richard Huxton @ 2001-03-03 15:13 UTC (permalink / raw)
  To: Jacek Zagorski <jaz@shastanetworks.com>; +Cc: pgsql-sql

Jacek Zagorski wrote:
> 
> Is it possible to INSERT into xyz
> where xyz is a view ?
> What is the proper syntax ?
> 
> Thanks Much
> Jacek Zagorski

You'll need to set up the rules for updating - PG can't figure out what
you want automatically. There's a page on this in the programmer's guide.

- Richard Huxton



^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2001-03-03 15:13 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-02-28 23:29 Insert into VIEW ??? Jacek Zagorski <jaz@shastanetworks.com>
2001-03-03 15:13 ` Richard Huxton <dev@archonet.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox