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

Filed under:

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

Related posts about postgresql