Newbie Questions, PostgreSQL

From: Sze Yuen Wong <swong_(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Newbie Questions, PostgreSQL
Date: 1998-10-15 17:13:07
Message-ID: 19981015171308.23853.rocketmail@send203.yahoomail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hi,

I'm new to PostgreSQL and I've got the following questions:

1.What is wrong with the following PostgreSQL statement?

CREATE RULE r1 AS ON INSERT TO TBL1 DO [INSERT INTO TBL2 values
(new.i);
NOTIFY TBL2];

I got the following error messages following its execution:

ERROR: parser: parse error at pr near ""
ERROR: parser: parse error at pr near "]"

++++++++++++++++++++++++++++++++++++++++++++++++++++

2. When I type \E and \e to the psql prompt, there does not
seem to be any difference: both invoke vi and execute my SQL
statement upon exit from vi. My understanding is that \E should do
execution following editing whereas \e does do editing. Am I right?

Thank you very much.

Sze Wong

_________________________________________________________
DO YOU YAHOO!?
Get your free @yahoo.com address at http://mail.yahoo.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Taral 1998-10-15 18:30:34 RE: [GENERAL] Newbie Questions, PostgreSQL
Previous Message Andrea Antibo 1998-10-15 07:34:39 Re: [GENERAL] make[2]: *** [psql] Error 1