Hello
2010/11/25 Ana Louro <anaoliveiralouro@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
>