Ubence Quevedo schrieb: > What would be the correct way to set up a dynamic > variable? I did some further research on my question > below, and I still don't have a definite answer to > whether or not use \set or SET. I did read at > http://www.commandprompt.com/ppbook/x19832 about using > variables in a Function, but that seems like an awful > lot to do [or does MS SQL make it easier than > PostgreSQL?]. Any help, ideas, or clarification are > much appreciated. Dont mix frontend and backend in your approach. You can specify variables in whatever way your stored function handles it (e.g. it depends on the language you use. Examples for pl/pgsql are in the docs.) In Postgres you dont write arbitrary code to the server. You write stored functions (server side) or you write SQL statements. Any further variable handling is up to your host/application language. psql, the command line client application does not have variables as such nor any flow control. Regards Tino Wildenhain
