Re: [SQL] Create function statement with insert statement

2003-03-17 Thread Susan Hoddinott
s. Thanks for all your assistance. Regards - Original Message - From: "Christoph Haller" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Monday, March 17, 2003 7:25 PM Subject: Re: [SQL] Create function statement with insert statemen

Re: [SQL] Create function statement with insert statement

2003-03-13 Thread Ian Harding
I think the language needs to be in quotes ... ... ' language 'sql'; >>> "Jon Griffin" <[EMAIL PROTECTED]> 03/12/03 11:59AM >>> You need to put your aliases in: value1 alias for $1; etc. Hello, > > I am trying to create a database trigger which inserts into a second > table. I have created the

Re: [SQL] Create function statement with insert statement

2003-03-13 Thread Christoph Haller
Hello Susan, > > The relevant code for creating the hexorders table (and associated > constraints) is: > > > DROP TABLE HEXORDERS ; > > DROP SEQUENCE HEXORDERS_SEQ ; > > CREATE SEQUENCE HEXORDERS_SEQ START 1 ; > > CREATE TABL