[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re: [GENERAL] Correct way to set up Variables [Was - Simple Accumulating
From:       Tino Wildenhain <tino () wildenhain ! de>
Date:       2005-12-30 23:57:14
Message-ID: 43B5C95A.407 () wildenhain ! de
[Download RAW message or body]

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

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
       subscribe-nomail command to majordomo@postgresql.org so that your
       message can get through to the mailing list cleanly
[prev in list] [next in list] [prev in thread] [next in thread]