how to declare variable in PostgreSQL
Posted
by user307880
on Stack Overflow
See other posts from Stack Overflow
or by user307880
Published on 2010-04-19T11:11:13Z
Indexed on
2010/04/19
12:23 UTC
Read the original article
Hit count: 210
postgresql
I try to declare a variable in a code like this, but it's doesn't work. Can you tell me what's the problem? ERROR: syntax error at or near "VARCHAR" LINE 2: p_country VARCHAR;
DECLARE p_country VARCHAR; p_country : = ''; SELECT p_country;
© Stack Overflow or respective owner