Hello 2010/11/25 Ana Louro <anaoliveiralo...@gmail.com>: > Hi, > I'm just beggining in PostgreSql 9.0 > > I've created a table ,like this: > > CREATE TABLE auxiliar > ( > ano integer, > codigodc character varying, > id character varying, > concat_id character varying NOT NULL, > CONSTRAINT concat PRIMARY KEY (concat_id); > > Now i want to insert values on concat_id resulting from a function > called "concat_id" > > INSERT INTO concat_id > SELECT(concat_id) FROM auxiliar ;
insert has a syntax: INSERT INTO <tablename> function call has a syntax funcname(parameters) so if I would to fill table auxiliar from some function, then I'll use a statement INSERT INTO auxilar SELECT * FROM funcname(..) Regards Pavel Stehule > > I get "error null value in column"concat_id" violatres not null > constraint > > > > Could anyone tell me what am i doing wrong? > > Ana > > > > > > -- > Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-sql > -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
