d_seq');
return inserted_row;
end;
$$;
Hope there is no syntax error.
Best Regards,
Otto
- Original Message -
From: "Matt A." <[EMAIL PROTECTED]>
To:
Sent: Sunday, August 21, 2005 9:56 PM
Subject: [SQL] returning inserted id
this may have been asked a thousand
On Sun, Aug 21, 2005 at 12:56:27 -0700,
"Matt A." <[EMAIL PROTECTED]> wrote:
> this may have been asked a thousand times but i
> haven't found a standard answer...
>
>
> MSSQL
> set nocount on
> insert into (column) values (value)
> select identityid = @@identity
> set nocount off
>
>
> POSTG
this may have been asked a thousand times but i
haven't found a standard answer...
MSSQL
set nocount on
insert into (column) values (value)
select identityid = @@identity
set nocount off
POSTGRESQL
*cricket cricket* :)
How is this done? By a trigger function? Or is it
natively supported? Coul
