X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (av.hub.org [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 31DB3D725F
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Sun, 21 Aug 2005 21:43:34 -0300 (ADT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 20118-02
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Mon, 22 Aug 2005 00:43:31 +0000 (GMT)
Received: from hotmail.com (bay101-dav8.bay101.hotmail.com [64.4.56.80])
	by svr1.postgresql.org (Postfix) with ESMTP id 3E350D7215
	for <pgsql-sql@postgresql.org>; Sun, 21 Aug 2005 21:43:30 -0300 (ADT)
Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC;
	Sun, 21 Aug 2005 17:43:34 -0700
Message-ID: <BAY101-DAV8EA3AA3EF2A17C6F7C9EEA3B60@phx.gbl>
Received: from 64.4.56.204 by BAY101-DAV8.phx.gbl with DAV;
	Mon, 22 Aug 2005 00:43:34 +0000
X-Originating-IP: [64.4.56.204]
X-Originating-Email: [michaelmschmidt@msn.com]
X-Sender: michaelmschmidt@msn.com
From: "Michael Schmidt" <MichaelMSchmidt@msn.com>
To: <pgsql-sql@postgresql.org>
Subject: Numerical variables in pqsql statements
Date: Sun, 21 Aug 2005 18:43:33 -0600
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0004_01C5A680.3BBE5040"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: MSN 9
X-MimeOLE: Produced By MSN MimeOLE V9.10.0011.1703
Seal-Send-Time: Sun, 21 Aug 2005 18:43:33 -0600
X-OriginalArrivalTime: 22 Aug 2005 00:43:34.0486 (UTC)
	FILETIME=[86BD2760:01C5A6B2]
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=1.43 required=5 tests=[AWL=-0.416,
	DNS_FROM_RFC_ABUSE=0.374, DNS_FROM_RFC_POST=1.376, HTML_50_60=0.095,
	HTML_MESSAGE=0.001, MSGID_FROM_MTA_HEADER=0]
X-Spam-Level: *
X-Archive-Number: 200508/253
X-Sequence-Number: 22481

This is a multi-part message in MIME format.

------=_NextPart_000_0004_01C5A680.3BBE5040
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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 function that included the statement :

CREATE TEMPORARY TABLE author_names AS=20
      SELECT ra.ref_auth_key, a.last_name, a.first_name=20
      FROM ref_auth ra INNER JOIN authors a
      ON (ra.author_num =3D a.author_key)=20
      WHERE ra.ref_num =3D refer_num;

where refer_num is integer.  This worked (surprisingly, to me).  So, =
what is the rule regarding variables?  Would this query work if I =
concatenated a string together, including quote_literal(refer_num) and =
then EXECUTEd it?

Thanks and sorry to be so stupid.
------=_NextPart_000_0004_01C5A680.3BBE5040
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type =
content=3Dtext/html;charset=3Diso-8859-1>
<STYLE></STYLE>

<META content=3D"MSHTML 6.00.2800.1515" name=3DGENERATOR></HEAD>
<BODY id=3DMailContainerBody=20
style=3D"PADDING-LEFT: 10px; FONT-WEIGHT: normal; FONT-SIZE: 12pt; =
COLOR: #000000; BORDER-TOP-STYLE: none; PADDING-TOP: 15px; FONT-STYLE: =
normal; FONT-FAMILY: Times New Roman; BORDER-RIGHT-STYLE: none; =
BORDER-LEFT-STYLE: none; TEXT-DECORATION: none; BORDER-BOTTOM-STYLE: =
none"=20
leftMargin=3D0 topMargin=3D0 acc_role=3D"text" CanvasTabStop=3D"true"=20
name=3D"Compose message area"><!--[gte IE 5]><?xml:namespace =
prefix=3D"v" /><?xml:namespace prefix=3D"o" /><![endif]-->
<DIV>Folks,</DIV>
<DIV>I'm sure this is dumb, but I'm a little confused about use of =
numerical=20
variables in pqsql.&nbsp; It was my impression one had to use EXECUTE on =
a=20
concatenated string including quote_literal() for the variable =
containing the=20
value.&nbsp; This can be quite a bit of trouble.&nbsp; I just wrote a=20
function&nbsp;that included the statement :</DIV>
<DIV>&nbsp;</DIV>
<DIV>CREATE TEMPORARY TABLE author_names AS =
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
SELECT ra.ref_auth_key, a.last_name, a.first_name=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; FROM ref_auth ra INNER JOIN authors=20
a<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ON (ra.author_num =3D a.author_key)=20
<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; WHERE ra.ref_num =3D refer_num;</DIV>
<DIV>&nbsp;</DIV>
<DIV>where refer_num is integer.&nbsp; This worked (surprisingly, to =
me).&nbsp;=20
So, what is the rule regarding variables?&nbsp; Would this query work if =
I=20
concatenated a string together, including quote_literal(refer_num) and =
then=20
EXECUTEd it?</DIV>
<DIV>&nbsp;</DIV>
<DIV>Thanks and sorry to be so stupid.</DIV></BODY></HTML>

------=_NextPart_000_0004_01C5A680.3BBE5040--