ERROR for '@' for function

From: Sachin Srivastava <ssr(dot)teleatlas(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: ERROR for '@' for function
Date: 2016-01-20 11:42:35
Message-ID: CAFzqEhKHxLnSYuGjk-q9mqN0kqBE_MUtpM2z8W8m=8=4SnH0Hg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

How to handle this below situation, I am getting error for function, my
Postgres version is 9.4
is

ERROR: syntax error at or near "@"
LINE 67: AUTONUMBERSETTING(at)REPOS(dot)BIRCHSTREET(dot)NET
^
********** Error **********
ERROR: syntax error at or near "@"
SQL state: 42601
Character: 3274

------------------------

BEGIN
select NEXT_NUMBER into STRICT id from
AUTONUMBERSETTING(at)REPOS(dot)BIRCHSTREET(dot)NET
--pbeach_repos8.AUTONUMBERSETTING
where subscriber_id=subscriber and AUTO_NUMBER_ID=348 and company_id=
buyer;
exception
when no_data_found then
insert into
smerror_log(error_log_id,subscriber_id,company_id,error_message,system_message,
method_name,creation_date,creation_user,update_date,update_user)
values (nextval('smerror_log_sequence'),subscriber,buyer,'Auto Number
not found',null,
'PunchoutProfile' ,LOCALTIMESTAMP,'Admin',LOCALTIMESTAMP,'Admin');
commit;
return;
end;

-------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Kellerer 2016-01-20 11:48:12 Re: ERROR for '@' for function
Previous Message Steve Rogerson 2016-01-20 11:10:53 Postgres and timezones