Postgres Pro
Downloads
Home   >   mailing lists

Inserts using plpgsql - Mailing list pgsql-general

From Scott Holmes
Subject Inserts using plpgsql
Date
Msg-id 200105171901.MAA10789@scotts.mynetwork.net
Whole thread Raw
List pgsql-general
Tree view 
It seems I can insert only a single field using plpgsql.

 INSERT INTO journal (j_date, evntnmbr) VALUES (jdate, param); Fails


 INSERT INTO journal (j_date) VALUES (jdate); Works

j_date is a date field while evntnmbr with it's associated variable, param,
are integers.  Can someone explain this for me please?

Thanks.

pgsql-general by date:

Previous
From: Daniel Wickstrom
Date:
Subject: Re: outer join fails with error - solaris only
Next
From: "Brent R. Matzelle"
Date:
Subject: Re: What's the best front end/client under MS Windows?