[SQL] Re: Create table syntax

2001-08-30 Thread Arne Weiner
satish rao wrote: > > Hi > > Entered below is the SQL create table syntax: > > CREATE TABLE lists ( > [listid] [int] IDENTITY (1, 1) NOT NULL , > [listname] [varchar] (200) NULL , > [listcreator] [varchar] (200) NULL , > [listdesc] [text] NULL) > > We need to kn

[SQL] Re: create table

2001-05-04 Thread Joel Burton
On Sun, 29 Apr 2001, LeoDeBeo wrote: > can anybody explain me the syntax of Create Table documentation?? This doc is much improved in the more recent PG create table help. Check out the online 7.1 Reference Manual, and there's a much nicer CREATE TABLE grammar. -- Joel Burton <[EMAIL PROTEC

Re: [SQL] RE: Create table in functions

2000-08-31 Thread Jan Wieck
Andreas Tille wrote: > On Thu, 24 Aug 2000, Hiroshi Inoue wrote: > > > Hmm,Andreas's original function seems to contain other statements. > > If the function contains DML statements for the table Temp_Num_Table, > > it wouldn't work properly. i.e 1st call would work but 2nd call woudn't. > That's

[SQL] RE: Create table in functions

2000-08-25 Thread Andreas Tille
On Thu, 24 Aug 2000, Hiroshi Inoue wrote: > Hmm,Andreas's original function seems to contain other statements. > If the function contains DML statements for the table Temp_Num_Table, > it wouldn't work properly. i.e 1st call would work but 2nd call woudn't. That's the problem. I'm in the process