DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
	b=aI8NSj0XvR5HTsYWc1RCB3s3WYDltlGWRfQHPURg5jhzFTggCys+QBg/N5PDfRvtVVo7EIMUapS62VvoMQjyBLKDQZa7SeB5jvOqZKqYYutfHIVNrQNwkboOcca8zIJzfkgMTTx697G4QuXDAZDtz1BtJ4rRYwdx80PNsV7Bbu8=
Message-ID: <7104a7370505190042692d6649@mail.gmail.com>
Date: Thu, 19 May 2005 10:42:32 +0300
From: Volkan YAZICI <volkan.yazici@gmail.com>
Reply-To: Volkan YAZICI <volkan.yazici@gmail.com>
To: bandeng <postgredb@gmail.com>
Subject: Re: postgre variable
Cc: pgsql-sql@postgresql.org
In-Reply-To: <3817e22905051819111a04c2fe@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
References: <3817e22905051819111a04c2fe@mail.gmail.com>

Hi,

On 5/19/05, bandeng <postgredb@gmail.com> wrote:
> i want to make dynamic sql query like this
>=20
> select * from tb_cust where name=3D'erick' and age=3D'20'
>=20
> to
>=20
> select * from tb_cust $1
>=20
> i have tried but error comeup

I think there's a confusion about the usage of parameters like $1, $2,
... etc. You cannot use parameters for a whole statement like "where
name=3D'erick' and age=3D'20'" or "name=3D'erick'". It's only useful to
point returned fields. Namely, above SQL query should be:

SELECT * FROM tb_cust WHERE name =3D $1 AND age =3D $2;

Plus beware it doesn't need quotes around parameter. Moreover, if
you're using some PostgreSQL API, you don't need to escape data
inserted by parameters. You may refer to documentation for further
information.

Regards.