Re: [SQL] Fw:

2003-02-21 Thread Daniel Schuchardt
Your ipc-daemon-version is to old. Download the newest version first. (1.13) Daniel ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html

Re: [SQL] function has no parameter $1 - help.

2003-02-07 Thread Daniel Schuchardt
In 7.3 you can also CREATE OR REPLACE FUNCTION xxx() RETURNS TRIGGER AS' BEGIN END'LANGUAGE plpgsql; ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [SQL] Inherancing

2003-01-13 Thread Daniel Schuchardt
You have to insert in th centers-table. Because it is inherited from cities, the record is automatically in cities. Search for SELECT * FROM ONLY in the docs too. create table cities (id int, name varchar, primary key(id) ); create table centers (state varchar(2)) inherits (cities); ant the