I'm converting a MSSQL query to postgresql. It's something like this:
SET NOCOUNT ON;
INSERT INTO table_name([list]) VALUES([list]);
SELECT SCOPE_IDENTITY() as newId;
I get an error on the NOCOUNT statement:
"syntax error at or near "on" at character 13"
So, I'm wondering if NOCOUNT is supported in Postgres at all. If it's
not, what's the alternative? If it is, what is wrong with my syntax?
I haven't gotten there yet, but I'm also wondering if the
SCOPE_IDENTITY() method is going to work or not.
TIA
-Jeff
This email is intended only for the individual or entity to which it is addressed. This email may contain information
thatis privileged, confidential or otherwise protected from disclosure. Dissemination, distribution or copying of this
e-mailor any attachments by anyone other than the intended recipient, or an employee or agent responsible for
deliveringthe message to the intended recipient, is prohibited. If you are not the intended recipient of this message
orthe employee or agent responsible for delivery of this email to the intended recipient, please notify the sender by
replyingto this message and then delete it from your system. Any use, dissemination, distribution, or reproduction of
thismessage by unintended recipients is strictly prohibited and may be unlawful.