Re: [SQL] Numerical variables in pqsql statements

2005-08-30 Thread Thomas F. O'Connell
Well, browse through this list: http://www.postgresql.org/docs/books/ I can't make any recommendations, as I am fairly familiar with the online documentation, which, when supported by the community, seems to be pretty good. -- Thomas F. O'Connell Co-Founder, Information Architect Sitening,

Re: [SQL] Numerical variables in pqsql statements

2005-08-29 Thread Thomas F. O'Connell
Michael, PL/pgSQL variable interpolation works similarly to that in other popular programming languages. If you have a statement -- whether it's PERFORM, SELECT INTO, or EXECUTE -- a variable will get interpolated during parsing if not escaped in a string. Per the documentation, dynamic v

[SQL] Numerical variables in pqsql statements

2005-08-26 Thread Michael Schmidt
Folks, I'm sure this is dumb, but I'm a little confused about use of numerical variables in pqsql.  It was my impression one had to use EXECUTE on a concatenated string including quote_literal() for the variable containing the value.  This can be quite a bit of trouble.  I just wrote a funct