Thread: postgre variable

hello all,

i want to make dynamic sql query like this

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

to

select * from tb_cust $1

i have tried but error comeup

any suggestion?

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

bandeng wrote:
> hello all,
> 
> i want to make dynamic sql query like this
> 
> select * from tb_cust where name='erick' and age='20'
> 
> to
> 
> select * from tb_cust $1
> 
> i have tried but error comeup

You have tried what? How? What error did you get?

--   Richard Huxton  Archonet Ltd

Hi,

On 5/19/05, bandeng <postgredb@gmail.com> wrote:
> i want to make dynamic sql query like this
>
> select * from tb_cust where name='erick' and age='20'
>
> to
>
> select * from tb_cust $1
>
> 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='erick' and age='20'" or "name='erick'". It's only useful to
point returned fields. Namely, above SQL query should be:

SELECT * FROM tb_cust WHERE name = $1 AND age = $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.

You should considder a variation as Volkan suggested.

Otherwise the EXECUTE command might be what you are looking for.
Execute a sql made up in a string

|-----Original Message-----
|From: bandeng [mailto:postgredb@gmail.com]
|Sent: Donnerstag, 19. Mai 2005 04:11
|To: pgsql-sql@postgresql.org
|Subject: [SQL] postgre variable
|
|
|hello all,
|
|i want to make dynamic sql query like this
|
|select * from tb_cust where name='erick' and age='20'
|
|to
|
|select * from tb_cust $1
|
|i have tried but error comeup
|
|any suggestion?
|
|thanks
|Ricky
|-- 
|Gutten Aben Sugeng Sonten, Jangane Kurang Santen
|bandeng....................
|
|---------------------------(end of 
|broadcast)---------------------------
|TIP 9: the planner will ignore your desire to choose an index 
|scan if your
|      joining column's datatypes do not match
|