Unexpected end of input in Postgresql stored procedure multidimensial array parameterSelect columns from result set of stored procedureWhat is a stored procedure?Insert results of a stored procedure into a temporary tableList of Stored Procedures/Functions Mysql Command LineWhere does PostgreSQL store the database?Function vs. Stored Procedure in SQL ServerExecute stored procedure with an Output parameter?How to pass an array into a SQL Server stored procedureSearch text in stored procedure in SQL ServerPassing json containing array of objects to PostgreSQL function throws malformed array literal. Unexpected array element
Minimum population for language survival
Will some rockets really collapse under their own weight?
What is the purpose/function of this power inductor in parallel?
Good way to stop electrolyte tabs from turning into powder?
Is this bar slide trick shown on Cheers real or a visual effect?
What should I do if actually I found a serious flaw in someone's PhD thesis and an article derived from that PhD thesis?
Can anybody tell me who this Pokemon is?
Do I need to start off my book by describing the character's "normal world"?
Why should I pay for an SSL certificate?
Meaning of だけはわからない
Is there a fallacy about "appeal to 'big words'"?
The space of cusp forms for GL_2 over F_q(T)
Is nullptr falsy?
How to gracefully leave a company you helped start?
Did Michelle Obama have a staff of 23; and Melania have a staff of 4?
Knights and Knaves on a (Not So) Deserted Island
How do I answer an interview question about how to handle a hard deadline I won't be able to meet?
Unconventional examples of mathematical modelling
Is there a way, other than having a Diviner friend, for a player to avoid rolling Initiative at the start of a combat?
Output with the same length always
Is Fourier series a sampled version of Fourier transform?
Set theory with antielements?
Short comic about alien explorers visiting an abandoned world with giant statues that turn out to be alive but move very slowly
What are these panels underneath the wing root of a A380?
Unexpected end of input in Postgresql stored procedure multidimensial array parameter
Select columns from result set of stored procedureWhat is a stored procedure?Insert results of a stored procedure into a temporary tableList of Stored Procedures/Functions Mysql Command LineWhere does PostgreSQL store the database?Function vs. Stored Procedure in SQL ServerExecute stored procedure with an Output parameter?How to pass an array into a SQL Server stored procedureSearch text in stored procedure in SQL ServerPassing json containing array of objects to PostgreSQL function throws malformed array literal. Unexpected array element
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty margin-bottom:0;
I have built stored procedure in PostgreSql which accept multidimensial array parameters like below
SELECT horecami.insert_obj_common(
'"(5, 2, LLLLL rest, 46181, a@a.com, ooo, kkk, 12:09, 20:40, 23, true, 49.667, 48.232, fu, 2011-12-15 15:28:19+04, 2011-12-15 15:28:19+04, 3, 1)"'::obj_special[],
' ')"'::obj_soft[]
);
Inside this procedure there ara foreach loops that works without problem.
But when i added last extra parametr as array (horecami.obj_soft_hardware[]) it gives me malformed array error.
This is error
ERROR: malformed array literal: "{"(1, 3, q1, q2, q3, q4, qson latest, true, 2011-12-15 15:28:19+04, 2, 2, 3, 2011-12-15 15:28:19+04, "
LINE 3: '{"(1, 3, q1, q2, q3, q4, qson latest, true, 2011-12-15 1...
^
DETAIL: Unexpected end of input.
SQL state: 22P02
Character: 202
It must return number
I guess this syntac error.
Thanks beforehands.
postgresql stored-procedures postgresql-9.4
asked Mar 27 at 12:32
Azer QurbanovAzer Qurbanov
337 bronze badges
add a comment |
I have built stored procedure in PostgreSql which accept multidimensial array parameters like below
SELECT horecami.insert_obj_common(
'"(5, 2, LLLLL rest, 46181, a@a.com, ooo, kkk, 12:09, 20:40, 23, true, 49.667, 48.232, fu, 2011-12-15 15:28:19+04, 2011-12-15 15:28:19+04, 3, 1)"'::obj_special[],
' ')"'::obj_soft[]
);
Inside this procedure there ara foreach loops that works without problem.
But when i added last extra parametr as array (horecami.obj_soft_hardware[]) it gives me malformed array error.
This is error
ERROR: malformed array literal: "{"(1, 3, q1, q2, q3, q4, qson latest, true, 2011-12-15 15:28:19+04, 2, 2, 3, 2011-12-15 15:28:19+04, "
LINE 3: '{"(1, 3, q1, q2, q3, q4, qson latest, true, 2011-12-15 1...
^
DETAIL: Unexpected end of input.
SQL state: 22P02
Character: 202
It must return number
I guess this syntac error.
Thanks beforehands.
postgresql stored-procedures postgresql-9.4
asked Mar 27 at 12:32
Azer QurbanovAzer Qurbanov
337 bronze badges
add a comment |
I have built stored procedure in PostgreSql which accept multidimensial array parameters like below
SELECT horecami.insert_obj_common(
'"(5, 2, LLLLL rest, 46181, a@a.com, ooo, kkk, 12:09, 20:40, 23, true, 49.667, 48.232, fu, 2011-12-15 15:28:19+04, 2011-12-15 15:28:19+04, 3, 1)"'::obj_special[],
' ')"'::obj_soft[]
);
Inside this procedure there ara foreach loops that works without problem.
But when i added last extra parametr as array (horecami.obj_soft_hardware[]) it gives me malformed array error.
This is error
ERROR: malformed array literal: "{"(1, 3, q1, q2, q3, q4, qson latest, true, 2011-12-15 15:28:19+04, 2, 2, 3, 2011-12-15 15:28:19+04, "
LINE 3: '{"(1, 3, q1, q2, q3, q4, qson latest, true, 2011-12-15 1...
^
DETAIL: Unexpected end of input.
SQL state: 22P02
Character: 202
It must return number
I guess this syntac error.
Thanks beforehands.
postgresql stored-procedures postgresql-9.4
asked Mar 27 at 12:32
Azer QurbanovAzer Qurbanov
337 bronze badges
I have built stored procedure in PostgreSql which accept multidimensial array parameters like below
SELECT horecami.insert_obj_common(
'"(5, 2, LLLLL rest, 46181, a@a.com, ooo, kkk, 12:09, 20:40, 23, true, 49.667, 48.232, fu, 2011-12-15 15:28:19+04, 2011-12-15 15:28:19+04, 3, 1)"'::obj_special[],
' ')"'::obj_soft[]
);
Inside this procedure there ara foreach loops that works without problem.
But when i added last extra parametr as array (horecami.obj_soft_hardware[]) it gives me malformed array error.
This is error
ERROR: malformed array literal: "{"(1, 3, q1, q2, q3, q4, qson latest, true, 2011-12-15 15:28:19+04, 2, 2, 3, 2011-12-15 15:28:19+04, "
LINE 3: '{"(1, 3, q1, q2, q3, q4, qson latest, true, 2011-12-15 1...
^
DETAIL: Unexpected end of input.
SQL state: 22P02
Character: 202
It must return number
I guess this syntac error.
Thanks beforehands.
postgresql stored-procedures postgresql-9.4
postgresql stored-procedures postgresql-9.4
asked Mar 27 at 12:32
Azer QurbanovAzer Qurbanov
337 bronze badges
asked Mar 27 at 12:32
Azer QurbanovAzer Qurbanov
337 bronze badges
asked Mar 27 at 12:32
Azer QurbanovAzer Qurbanov
337 bronze badges
asked Mar 27 at 12:32
Azer QurbanovAzer Qurbanov
337 bronze badges
asked Mar 27 at 12:32
Azer QurbanovAzer Qurbanov
337 bronze badges
337 bronze badges
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
You don't have a multi-dimensional array; you've got an array containing a composite type, which in turn contains an array containing a composite type.
When writing this as a string literal, certain characters have to be escaped (e.g. strings with spaces need quotes, and those quotes need escaping). Then at nested levels they all need to be double quoted and escaped.
To determine what the string literal should look like, just create it using actual arrays and rows (or composite types), then cast to text to get the literal string value with all fields correctly quoted and escaped:
SELECT ARRAY[ROW(1, 3, 'q1', 'q2', 'q3', 'q4', 'qson latest', ARRAY[ROW(1, 1, 1, 1, 1)])]::TEXT
Returns:
"(1,3,q1,q2,q3,q4,"qson latest","""(1,1,1,1,1)""")"
answered Mar 27 at 12:44
404404
3,5591 gold badge10 silver badges32 bronze badges
Thank you very much
– Azer Qurbanov
Mar 27 at 17:09
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55377287%2funexpected-end-of-input-in-postgresql-stored-procedure-multidimensial-array-para%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
You don't have a multi-dimensional array; you've got an array containing a composite type, which in turn contains an array containing a composite type.
When writing this as a string literal, certain characters have to be escaped (e.g. strings with spaces need quotes, and those quotes need escaping). Then at nested levels they all need to be double quoted and escaped.
To determine what the string literal should look like, just create it using actual arrays and rows (or composite types), then cast to text to get the literal string value with all fields correctly quoted and escaped:
SELECT ARRAY[ROW(1, 3, 'q1', 'q2', 'q3', 'q4', 'qson latest', ARRAY[ROW(1, 1, 1, 1, 1)])]::TEXT
Returns:
"(1,3,q1,q2,q3,q4,"qson latest","""(1,1,1,1,1)""")"
answered Mar 27 at 12:44
404404
3,5591 gold badge10 silver badges32 bronze badges
Thank you very much
– Azer Qurbanov
Mar 27 at 17:09
add a comment |
You don't have a multi-dimensional array; you've got an array containing a composite type, which in turn contains an array containing a composite type.
When writing this as a string literal, certain characters have to be escaped (e.g. strings with spaces need quotes, and those quotes need escaping). Then at nested levels they all need to be double quoted and escaped.
To determine what the string literal should look like, just create it using actual arrays and rows (or composite types), then cast to text to get the literal string value with all fields correctly quoted and escaped:
SELECT ARRAY[ROW(1, 3, 'q1', 'q2', 'q3', 'q4', 'qson latest', ARRAY[ROW(1, 1, 1, 1, 1)])]::TEXT
Returns:
"(1,3,q1,q2,q3,q4,"qson latest","""(1,1,1,1,1)""")"
answered Mar 27 at 12:44
404404
3,5591 gold badge10 silver badges32 bronze badges
Thank you very much
– Azer Qurbanov
Mar 27 at 17:09
add a comment |
You don't have a multi-dimensional array; you've got an array containing a composite type, which in turn contains an array containing a composite type.
When writing this as a string literal, certain characters have to be escaped (e.g. strings with spaces need quotes, and those quotes need escaping). Then at nested levels they all need to be double quoted and escaped.
To determine what the string literal should look like, just create it using actual arrays and rows (or composite types), then cast to text to get the literal string value with all fields correctly quoted and escaped:
SELECT ARRAY[ROW(1, 3, 'q1', 'q2', 'q3', 'q4', 'qson latest', ARRAY[ROW(1, 1, 1, 1, 1)])]::TEXT
Returns:
"(1,3,q1,q2,q3,q4,"qson latest","""(1,1,1,1,1)""")"
answered Mar 27 at 12:44
404404
3,5591 gold badge10 silver badges32 bronze badges
You don't have a multi-dimensional array; you've got an array containing a composite type, which in turn contains an array containing a composite type.
When writing this as a string literal, certain characters have to be escaped (e.g. strings with spaces need quotes, and those quotes need escaping). Then at nested levels they all need to be double quoted and escaped.
To determine what the string literal should look like, just create it using actual arrays and rows (or composite types), then cast to text to get the literal string value with all fields correctly quoted and escaped:
SELECT ARRAY[ROW(1, 3, 'q1', 'q2', 'q3', 'q4', 'qson latest', ARRAY[ROW(1, 1, 1, 1, 1)])]::TEXT
Returns:
"(1,3,q1,q2,q3,q4,"qson latest","""(1,1,1,1,1)""")"
answered Mar 27 at 12:44
404404
3,5591 gold badge10 silver badges32 bronze badges
answered Mar 27 at 12:44
404404
3,5591 gold badge10 silver badges32 bronze badges
answered Mar 27 at 12:44
404404
3,5591 gold badge10 silver badges32 bronze badges
answered Mar 27 at 12:44
404404
3,5591 gold badge10 silver badges32 bronze badges
3,5591 gold badge10 silver badges32 bronze badges
Thank you very much
– Azer Qurbanov
Mar 27 at 17:09
add a comment |
Thank you very much
– Azer Qurbanov
Mar 27 at 17:09
Thank you very much
– Azer Qurbanov
Mar 27 at 17:09
Thank you very much
– Azer Qurbanov
Mar 27 at 17:09
add a comment |
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Got a question that you can’t ask on public Stack Overflow? Learn more about sharing private information with Stack Overflow for Teams.
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55377287%2funexpected-end-of-input-in-postgresql-stored-procedure-multidimensial-array-para%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
