Re: [ADMIN] Binding Parameters

[Postgres User]

Do you mean PREPARE / EXECUTE?
/* [EMAIL PROTECTED]: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)
/* [EMAIL PROTECTED]:5432/ahammond =# */ SELECT * FROM foo;
~ foo_id | name
- --------+------
~      1 | a
~      2 | b
~      3 | c
~      4 | d
~      5 | f
(5 rows)
/* [EMAIL PROTECTED]:5432/ahammond =# */ PREPARE foo_name (integer) AS
SELECT name FROM foo WHERE foo_id = $1;
PREPARE
/* [EMAIL PROTECTED]:5432/ahammond =# */ EXECUTE foo_name (1);
~ name
- ------
~ a
(1 row)
/* [EMAIL PROTECTED]:5432/ahammond =# */ EXECUTE foo_name (4);
~ name
- ------
~ d
(1 row)
Thanks for the short tutorial... I think that I've gotten the point.  I 
was searching online and nothing proved useful.

Anymore more examples or direction on finding any of bind parameter is 
appreciated.
J

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings