[SQL] Need help form inherits

2004-08-01 Thread Patrice OLIVER
Hello everybody, I would like to use inherits between 2 tables : user(login,password) and studiant(firstname, lastname, email) these tables are created like this : create table user ( login varchar(15) not null primary key, password varchar(32)); create table studiant ( firstname varchar(35), lastn

Re: [SQL] How to create an aggregate?

2004-08-01 Thread Greg Stark
Ray Aspeitia <[EMAIL PROTECTED]> writes: > I also would like to pass the delimiter to the aggregate as a parameter and > I am not sure if it can handle that. Currently aggregates that take multiple parameters are just not supported. -- greg ---(end of broadcast)--

[SQL] Help on triggers

2004-08-01 Thread Pradeepkumar, Pyatalo (IE10)
Hi all, I have 2 tables - table1 and table2. Both the tables are related to each other. I have written triggers so that if a tuple is inserted into table1, corresponding values will be inserted into table2. and if a tuple is deleted from table1 then corresponding tuples are deleted from table2 al

[SQL] error in compiling the function -- need help !!!

2004-08-01 Thread Pradeepkumar, Pyatalo (IE10)
> Hi , > > I have attached the function that I am trying to run. But I am getting the > following error - > > select * from pp_readenum('STAT42','PointDefinitionType') as alias; > ERROR: syntax error at or near ";" > CONTEXT: compile of PL/pgSQL function "pp_readenum" near line 41 > <> > >

[SQL] org.postgresql.PG_Stream.ReceiveChar(PG_Stream.java:143)

2004-08-01 Thread Smita Marda
Hi, I have been using SOFIA framework and postgres database as a backend. i noticed as the database started growing larger.. today encountered some error while firing a query to save a record. The table in which i am going to save the record, has two columns having datatype text. the data of these