X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 0D2C9329E5C for ; Sat, 11 Sep 2004 19:13:56 +0100 (BST) 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 85409-03 for ; Sat, 11 Sep 2004 18:13:48 +0000 (GMT) Received: from mail.libertyrms.com (unknown [207.219.45.62]) by svr1.postgresql.org (Postfix) with ESMTP id 270BF329E47 for ; Sat, 11 Sep 2004 19:13:47 +0100 (BST) Received: from dba4.int.libertyrms.com ([10.1.3.13] ident=ahammond) by mail.libertyrms.com with esmtp (Exim 4.22) id 1C6CNe-0003Ak-SY; Sat, 11 Sep 2004 14:13:46 -0400 Message-ID: <4143408B.7040604@ca.afilias.info> Date: Sat, 11 Sep 2004 14:14:35 -0400 From: Andrew Hammond Organization: Afilias Canada Corp. User-Agent: Mozilla Thunderbird 0.7.3 (X11/20040830) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Postgres User Cc: pgsql-admin@postgresql.org Subject: Re: Binding Parameters References: <4142008A.2010108@productivitymedia.com> In-Reply-To: <4142008A.2010108@productivitymedia.com> X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-SA-Exim-Mail-From: ahammond@ca.afilias.info X-SA-Exim-Scanned: No; SAEximRunCond expanded to false X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=UPPERCASE_25_50 X-Spam-Level: X-Archive-Number: 200409/105 X-Sequence-Number: 14808 -----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Postgres User wrote: | I'm new to PostgreSQL, and am wondering for BindSQL is intergrated in | Postgres or in the future for version 8. | | Example: | | SELECT * FROM sample_table WHERE computer = :1; | | Any pointers will help. Do you mean PREPARE / EXECUTE? /* ahammond@[local]:5432/ahammond =# */ \d foo ~ Table "public.foo" ~ Column | Type | Modifiers - --------+---------+---------------------------------------------- ~ foo_id | integer | not null default nextval('foo_id_seq'::text) ~ name | text | not null Indexes: ~ "foo_id_idx" unique, btree (foo_id) ~ "foo_name_idx" unique, btree (name) /* ahammond@[local]:5432/ahammond =# */ SELECT * FROM foo; ~ foo_id | name - --------+------ ~ 1 | a ~ 2 | b ~ 3 | c ~ 4 | d ~ 5 | f (5 rows) /* ahammond@[local]:5432/ahammond =# */ PREPARE foo_name (integer) AS SELECT name FROM foo WHERE foo_id = $1; PREPARE /* ahammond@[local]:5432/ahammond =# */ EXECUTE foo_name (1); ~ name - ------ ~ a (1 row) /* ahammond@[local]:5432/ahammond =# */ EXECUTE foo_name (4); ~ name - ------ ~ d (1 row) - -- Andrew Hammond 416-673-4138 ahammond@ca.afilias.info Database Administrator, Afilias Canada Corp. CB83 2838 4B67 D40F D086 3568 81FC E7E5 27AF 4A9A -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.5 (GNU/Linux) iD8DBQFBQ0CJgfzn5SevSpoRAqyPAKDPM6BGRBT24nUJvaDePgcsBKVHhgCgyH0d /qANwzyTD/HyNbBYCxTOFic= =B1y3 -----END PGP SIGNATURE-----