X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id 69105528BA
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Wed, 18 May 2005 23:11:12 -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 48946-09
	for <pgsql-sql-postgresql.org@localhost.postgresql.org>;
	Thu, 19 May 2005 02:11:10 +0000 (GMT)
Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.196])
	by svr1.postgresql.org (Postfix) with ESMTP id 3E07B5280A
	for <pgsql-sql@postgresql.org>; Wed, 18 May 2005 23:11:09 -0300 (ADT)
Received: by zproxy.gmail.com with SMTP id 34so432435nzf
	for <pgsql-sql@postgresql.org>; Wed, 18 May 2005 19:11:13 -0700 (PDT)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com;
	h=received:message-id:date:from:reply-to:to:subject:mime-version:content-type:content-transfer-encoding:content-disposition;
	b=G9QvlHpZny2VfRoUMHlp/bMUF51RVcIBKKTdE/dVxBY8gGleHnUbcENJ80egZU0ooBU4WeXD1pM5StZ3VXWGcYy2bWvoJZuuOcje5zO9oqkBolvRbwZliHxEdXaazc0gZW6zGAtGZkHO0mrNoV0X0+1yLcMzWYakYVhsdpBr5is=
Received: by 10.36.57.20 with SMTP id f20mr370324nza;
	Wed, 18 May 2005 19:11:13 -0700 (PDT)
Received: by 10.36.67.5 with HTTP; Wed, 18 May 2005 19:11:13 -0700 (PDT)
Message-ID: <3817e22905051819111a04c2fe@mail.gmail.com>
Date: Thu, 19 May 2005 10:11:13 +0800
From: bandeng <postgredb@gmail.com>
Reply-To: bandeng <postgredb@gmail.com>
To: pgsql-sql@postgresql.org
Subject: postgre variable
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.258 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_ABUSE, RCVD_BY_IP
X-Spam-Level: 
X-Archive-Number: 200505/158
X-Sequence-Number: 21471

hello all,

i want to make dynamic sql query like this

select * from tb_cust where name=3D'erick' and age=3D'20'

to

select * from tb_cust $1

i have tried but error comeup

any suggestion?

thanks
Ricky
--=20
Gutten Aben Sugeng Sonten, Jangane Kurang Santen
bandeng....................