I have a rule setup on PostgreSQL to return a column after insert.
[sql] CREATE RULE get_projectkey_on_insert AS ON INSERT TO projects DO SELECT currval(('projects_id_seq'::text)::regclass) AS id;[/sql]
I use pg_prepare, and pg_execute
Code: Select all
$sql="insert into " . $this->TableName. " (username,companycode,projectname) values ($1,$2,$3)";
$this->result=@pg_prepare("projects_insert",$sql) or die(pg_errormessage());
Code: Select all
$this->result=@pg_execute("projects_insert",
array(
$GLOBALS["username"],
$GLOBALS["companycode"],
''
)
) or die(pg_errormessage());
Can you help?
Regards,
Pentium10